Chart Tools Homework 2 (Autosaved).xIsx - Excel File Insert Page Layout Formulas Data Review View Design Format ? Tell me what you want to do... Sign in A Share o Cut Calibri (Body) Wrap Text General Normal Bad Good Neutral Calculation 2 AutoSum 7O Paste Copy Merge & Center % Conditional Format as Check Cell Input Linked Cell Note Insert Delete Format Fill - Format Painter Sort & Find & Formatting Table Explanatory ... LC Filter - Select - Clipboard Font Alignment Number Style Cells Editing Chart 1 fox B G M AA AB AC Mortgage information Property Price $200,000 Loan A Loan B Loan Amount $150,000 Months 360 360 Down Payment $50,000 Loan amount $150,000 $150,000 TV 75 0% Rate 4.1% 4.0% Chart Area nterest rate 4.0% (annual) Points LAWN - D GO Compounding $716.12 Payment $724 $716.12 Proceeds $149,487.50 $149,500.00 Term 30 (in years) APR 4.10% 6.00% Loan payment $257,804.26 (principal & interest only) Your comment: Amortization Schedule Month Beg Interest Principal lance + $150,000 $500 $216 $140 interest and principal payment 5149.784 $217 $149,56 $149 567 $218 $149,349 $700 $149,349 $218 $149 $148,912 $148,912 $219 9,131 $600 $148 $148 8,692 $220 $400 $148,472 $300 Interest $148,251 48,251 $148,029 $200 -Principal $147,806 $100 $147,583 $0 $147,35 $147,13 month $146,908 $146,90 $146,681 End Balance $146,68 $146,45 $146,226 $160,000 $145,998 $140,000 $145,998 $145,768 $120,000 $145,768 $145,538 $230 $231 $145,307 $100,000 $232 $145,075 $80,00 $145,075 $144,843 $60,00 End Balance $144,843 $233 $234 $144,609 $40,00 $144,375 $144,609 $144,375 $235 $144,140 $20,000 $144,140 $480 $236 $143,905 $0 $143,905 $236 $143,668 Month LEZS $143, $143,431 $143,431 $478 $238 $143,193 $143,193 $239 LLVS $142,954 $142,954 $240 $142,71 Amortization +) Ready 05% H 2i x ] AV 70 4)ENG 13:51 11/15/2018