Question: I need this on excel 11. Cash Flow Estimation-Pro Forma Statements and Spreadsheet You are a new financial analyst at SST Inc., a large medical

I need this on excel  I need this on excel 11. Cash Flow Estimation-Pro Forma Statements
and Spreadsheet You are a new financial analyst at SST Inc., a

11. Cash Flow Estimation-Pro Forma Statements and Spreadsheet You are a new financial analyst at SST Inc., a large medical technology com- pany located in Dallas, Texas. The company has just developed and completed FDA testing for a new surgical staple tool that replaces sewn stitches. The mar- keting, production, and accounting departments have sent you the following memos and data. Use the data to compute cash flow estimates for the nevw product for the next 10 years. EXCEL From: SST Marketing Research Marketing surveys completed over the last 2 months indicate that initial interest in Product X-126, is very high. Based on confirmed adoption rates among survey par ticipants and proposed marketing plans for the product's introduction, estimated sales units and sales dollars are shown in the following table. The table also reflects introductory pricing and sales and price erosion due to competition. YEAR 8 9 10 Units Price Sales (5000s) 357 696 1,080 1,320 1,250 1,250 1,250 850 595 216 350 580 900 1,100 1,250 1,250 1,250 1,000 700 300 1,020 1,200 1,200 1,200 1,000 1,000 1,000 850 850 720 From: SST Production/Manufacturing Re: Product X-126 Production Costs Preliminary engineering reports estimate Product X-126 per-unit production costs- including all materials, labor, and absorbed indirect costs-to be

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!