AutoSave Off Module 9-... v Nolan O'Halloran NO AutoSave Off Module 9-... Nolan O'Halloran NO File Home Insert Page Layout Formulas Data Review View Automate Help B File Home Insert Page Layout Formulas X % Conditional Formatting % Data Review View Automate Help Conditional Formatting B Format as Table LG Paste Font Alignment Number Cells Editing Add-ins Analyze Paste Font Alignment Cell Styles Data B2 Clipboard Styles Add-ins : fx 5000000 Clipboard G44 : fx Number Cell Styles Styles Format as Table Cells Editing Add-ins Analyze Data Add-ins 1 2 Loan APR Payment Periods within the yea 5 Payments (total years of loan) Future value of loan B 9 Amortization table: 0 Period 1 2 3 4 5 6 7 8 9 20 1 2 23 4 25 26 27 28 9 =0 =1 2 33 4 35 6 :7 8 69 40 +1 +3 14 45 < > Ready 5,000,000.00 6.90% 12 6 0 D E F G H A B 1 Fixed Income 2,400,000 2 Life 15 3 Income tax Rate 0.17 4 Property Value (cost) 5,000,000 5 Salvage 1,500,000 6 Wages 349,000 7 Insurance 16,000 8 Maintenance and utility 20,000 9 10 11 Cumulative principal & interest payments: 12 13 Revenue Payments in year: Interest 15 Principal Interest Principal Balance Amortization Accessibility: Good to go Cash flow + E 14 Operating costs 16 Operating income 17 18 Interest Payments 19 Depreciation 20 21 Taxable income 22 23 Tax 24 After Tax income 25 Add depreciation 26 Principal Payments 27 28 Net Cash Flow + 63% 29 30 31 32 33 < Cash flow Ready Accessibility: Good to go C D E F G H + Year 4 6 + 84%