For week-1, use the Excel spreadsheet (using 5% increase) to answer the following:

Summary of Key Results

Calculations for 2014 and 2015

Income and Cash Flow Statement (Continue to Rent)

Income and Cash Flow Statement (Purchase House)

werk 1 Excr Lok Star Insert Page Layout Fomulas Data Review View Tell me what you want to do X Cut E Copy Normal Bad Irsert Delrte Format Sort Find& iler Select Check Cell Fommat Painter Br FurallingTable Calls Edr.ing C21 Tutorial Exercise Skeleton-Ted and Alice's House Decision Constants 2013 2014 2015 Noi-Housrg Lming Expenss (Cas, Food, Meical, etc Nortgage Arount for Home Purchase Roal Estato Tass and naurants on Homc iltes EspeHeat& Elec-Acartment utities Expenseteat, Electric, weter, Trash) Hcuse Hous Ropair and Maintenance Expenscs NA 200,000 6 53,000 200 $2,5002800 3.150 52 2110 NA 51,200 $1.400 2013 2014 2016 Renta Occupancy (H-High, L-Low) 14 1 Summery 1E End-al-year Cas n Hand ent) 17- End of year Cash on Hand |Buy of Key Results 2013 2014 2015 9 Calculations 20 Apartment Rent 21 House Payments 22 Interest Rate lur Hause Nortgage 14,400 2013 2014 2015 24 Income and Cash Flow Statement IConinue to Re 25 Eegnning-at-year Lash can Hand 2 Ted's Take Home Wages 27 Ako's Take Home salary 24,000 530.000 Hame Incame NA 29 Aprtimen Ret 30Unines (Apartment) - Nn-H:uing Livng Espenses Total Expenses 33 End-of-ycar Cashon Hand $4,000 Income and Cash Flow Satement 2013 2014 2016 Sheet1 ? ?- O Type here to search werk 1 Excr Lok Star Insert Page Layout Fomulas Data Review View Tell me what you want to do X Cut E Copy Normal Bad Irsert Delrte Format Sort Find& iler Select Check Cell Fommat Painter Br FurallingTable Calls Edr.ing C21 Tutorial Exercise Skeleton-Ted and Alice's House Decision Constants 2013 2014 2015 Noi-Housrg Lming Expenss (Cas, Food, Meical, etc Nortgage Arount for Home Purchase Roal Estato Tass and naurants on Homc iltes EspeHeat& Elec-Acartment utities Expenseteat, Electric, weter, Trash) Hcuse Hous Ropair and Maintenance Expenscs NA 200,000 6 53,000 200 $2,5002800 3.150 52 2110 NA 51,200 $1.400 2013 2014 2016 Renta Occupancy (H-High, L-Low) 14 1 Summery 1E End-al-year Cas n Hand ent) 17- End of year Cash on Hand |Buy of Key Results 2013 2014 2015 9 Calculations 20 Apartment Rent 21 House Payments 22 Interest Rate lur Hause Nortgage 14,400 2013 2014 2015 24 Income and Cash Flow Statement IConinue to Re 25 Eegnning-at-year Lash can Hand 2 Ted's Take Home Wages 27 Ako's Take Home salary 24,000 530.000 Hame Incame NA 29 Aprtimen Ret 30Unines (Apartment) - Nn-H:uing Livng Espenses Total Expenses 33 End-of-ycar Cashon Hand $4,000 Income and Cash Flow Satement 2013 2014 2016 Sheet1 ? ?- O Type here to search