# Speadsheet Model Template.xlsx - Title ASSUMPTION...

• 8

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.