New Microsoft Office Excel Worksheet

New Microsoft Office Excel Worksheet - services offered...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
S. No. FINDINGS 1 How many customers are considered relevant for the proposed CRM program? 2 3 How frequently does GST run acquisition campaigns?  4 On average, what does it cost GST to contact one customer? 5 6 7 8 9 10 What is the appropriate tax rate for the analysis?  11 What is GST’s appropriate required return for the analysis? What is the annual growth target for the relevant customer base embedded in the  strategic plan? Historically, what is the current average campaign take rate for acquisition  campaigns by GST customers? What does Teradata suggest as the anticipated improvement in the acquisition  campaign take rate? Currently, what is the average monthly revenue per GST customer for the relevant  customer base? What does Teradata propose as the anticipated increase in average monthly  revenue per customer? What is GST’s average incremental gross margin percentage on the goods and 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: services offered through the campaign? VALUES 13000000 0.05 Monthly $5 0.03 0.05 $42 0.2 0.4 0.38 0.16 One-time Costs – Payable at T=0 and Depreciated Using Straight-line Depreciation 1 Hardware (Nodes and Disk Array) 2 Software 3 Professional Services (Consulting) Ongoing Maintenance/Upgrade Fees – Billed at the End of the Monthly Professional Services (Consulting) Ongoing Maintenance/Upgrade Fees – Billed at the End of the Quarter 1 Hardware 2 Software Cancellation/Extension Fees 1 Cancellation Fee 2 Extension Fee Services $1,500,000 $2,500,000 $1,000,000 20%/yr of one-time cost, paid monthly 12%/yr of one-time cost, paid quarterly 18%/yr of one-time cost, paid quarterly Payment at time of cancellation totaling three months of ongoing PS, hardware and software charges Billed at current rates – maximum one year extension...
View Full Document

This note was uploaded on 06/26/2011 for the course INFRASTRUC 401 taught by Professor Adi during the Spring '11 term at Aims Community College.

Page1 / 4

New Microsoft Office Excel Worksheet - services offered...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online