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