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
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
Get step-by-step solutions from verified subject matter experts
