Question: Description In this assignment, you will develop a profit/loss forecast that includes development costs for your app and perform a sensitivity analysis on the profit/loss

Description In this assignment, you will develop a profit/loss forecast that includes development costs for your app and perform a sensitivity analysis on the profit/loss figure after 5 years. Guidelines Create an assumptions area containing all variables. Name each number in the assumptions area using camelback notation. Use those names in calculations in the spreadsheet. Except for the Year column, EVERY number outside of the Assumptions area must be calculated with formulas. Include a copyright symbol with your name at the bottom. Only the first number in each column gets formatted as CURRENCY (do not format as ACCOUNTING). Use the number format menu to remove the dollar sign from the other numbers in the column if needed. All other numbers greater than 1,000 should be in Comma style. Incorporate new costs including Incorporation ($199), Apple Developer Cost ($99/year), Advertising ($2,400/yr.), Developer maintenance cost ($1,000/yr.). Produce a sensitivity analysis table of total profit/(loss) as a function of growth rate and price per unit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
