Speadsheet Model Template.xlsx - Title ASSUMPTION...

This preview shows page 1 - 5 out of 8 pages.

Title: Downpayment saving plan for 2 year period ASSUMPTION PARAMETERS Current Savings $ 20,000.00 Annual savings Interest rate 2% Saving period (months) 24 VARIABLE PARAMETERS Scenario 1 (base) Scenario 2 Monthly income $ 3,000.00 $ 3,000.00 Expenses: Rent -$ 1,500.00 -$ 1,400.00 Utilities -$ 300.00 -$ 300.00 Enterteinment -$ 200.00 -$ 100.00 Food -$ 500.00 -$ 400.00 Scenario 2: Reduce rent, enterte Scenario 3: Keep all his expense GOAL (OUTPUT) Interest saving $ 800.00 $ 800.00 Saving after expenses $ 12,000.00 $ 19,200.00 TOTAL SAVINGS $ 32,800.00 $ 40,000.00
Scenario 3 $ 3,300.00 -$ 1,500.00 -$ 300.00 -$ 200.00 -$ 500.00 einment and food expenses by $100 each of them. es as scenario 1, but finding an extra source of income $ 800.00 $ 19,200.00 $ 40,000.00
Title: Downpayment saving plan for 2 year period ASSUMPTION PARAMETERS Current Savings $ 24,000.00 Annual savings Interest rate 2% Saving period (months) 24 VARIABLE PARAMETERS Scenario 1 (base) Scenario 2 Monthly income $ 3,000.00 $ 3,000.00 Expenses: Rent -$ 1,500.00 -$ 1,400.00 Utilities -$ 300.00 -$ 300.00 Enterteinment -$ 200.00 -$ 100.00 Food -$ 500.00 -$ 400.00 Scenario 2: Reduce rent, enterte Scenario 3: Keep all his expense GOAL (OUTPUT) Interest saving $ 960.00 $ 960.00 Saving after expenses $ 12,000.00 $ 19,200.00 TOTAL SAVINGS $ 36,960.00 $ 44,160.00
Scenario 3 $ 3,300.00 -$ 1,500.00 -$ 300.00 -$ 200.00 -$ 500.00 einment and food expenses by $100 each of them.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture