Question: I need help with this assignment. I have the spreadsheet completed but when I run the data table to do the sensitivity analysis to work
I need help with this assignment. I have the spreadsheet completed but when I run the data table to do the sensitivity analysis to work correctly, the table at the bottom, row 30 thru 35. The correct numbers are in the sheet below but they don't match mine. I'm sure I am putting in the incorrect info in the what if analysis data table. Thanks

SS File Home Insert Page Layout Formulas Data Review View Add-ins Help LOAD TEST Team Tell me what yo Calibri - 11 ab Wrap Text General % Cut @ Copy Format Painter Paste BIU- - A Merge & Center - $ - % 0.000 .00 0 Conditional Format Formatting Table Clipboard Font Alignment [5 Number T18 X fax A B C D E F G 1 iPhone App Forecast of Revenue and Costs 2 3 Assumptions 4 Units Year 1 700 5 Yearly Increase 100% 6 Price Per Unit $2.00 7 Apple Commission 30% 8 Contribution Margin per Unit $1.40 9 10 Fixed Costs 11 Developer Cost - Initial $3,500.00 year 1 only 12 Incorporation LLC $199.00 year 1 only 13 Developer Cost - Maintenance $1,000.00 yearly after year 1 14 Apple Developer License $99.00 yearly 15 Advertising $2,400.00 yearly 16 17 18 Year Units Contribution Margin Fixed Costs 19 1 700 $980 $6,198 20 2 1,400 1,960 3,499 21 3 2,800 3,920 3,499 22 4 4 5,600 7,840 3,499 23 5 11,200 15,680 3,499 24 Profit/(Loss) 25 26 5 year Profit/(Loss) as a function of Price per Unit and Yearly Increase 27 Scenarios highlighted in green are more profitable than initial assumptions 28 Profit ($5,218) (1,539) 421 4,341 12,181 $10,186 29 30 31 32 33 34 35 36 Price Per Unit Beginning 5 year Profit/(Loss) $10,186 $1.00 $2.00 $3.00 $4.00 $5.00 25% ($16,172.55) (12,151.11) (8,129.66) (4,108.22) (86.77) Yearly Increase 50% ($13,732.13) (7,270.25) (808.38) 5,653.50 12,115.38 75% ($10,124.12) (54.23) 10,015.65 20,085.53 30,155.41 100% ($5,004.00) 10,186.00 25,376.00 40,566.00 55,756.00 Add assumptions and columns as necessary to accommodate additional costs of maintenance, incorporation, and advertising
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
