Question

AutoSave OFF D U Home Insert Page Layout Formulas Data 8 Calibri (Body) - 11 A- A- BIUⓇA L' B 19 Paste * Office Update To keep up-to-date with security updates, fixes, a C17 A E B Bank A 400000 0.05 0.036 30 C D Bank B Bank C 400000 400000 0.09 0.12 0.032 0.028 3030 2 Apartment Price 3 Down Payment (%) 4 Interest Rate(%) 5 Terms of Loan (Years) 6 Down Payment Amount 7 Loan Amount 8 Monthly Payment 9 18 19

what are the formulas to get Row 6,7,8?

Answer 1

Book2 Microsoft Excel X Ca X Data Home Insert Page Layout Formulas Review View Cut E AutoSum AA Wrap Text Calibri 11 Custom Copy Fill Paste в I 1 Merge & Center % Insert Delete Format: Sort & Find & .00 .00 0 Conditional Format Cell BIU Format Painter Clear Formatting as Table Styles Filter Select Editing Clipboard Number Font Alignment Styles Cells -PMT(C7/12,360, C6, 0) f C9 A C F G н Bank A Bank B Bank C 2 3 Amount $ 4,00,000.00 400000 400000 4 Down Payment($400000*.05) for Bank A,($400000*.09) for Bank B and ($400000*.12) for Bank C Balance Amount 20,000.00 $ 3,80,000.00 $ 48000 5 36,000.00 $ 3,64,000.00 $ 6 3,52,000.00 Annual Interest rate 2.80% 3.60% 3.20% 7 Terms in years (30 12) Payment(3.5%/ 12),360, $400000, 0), (3.2%/12),360,$ 400000,0),((2.8%/12), 360, $400000,0) 360 8 360 360 $1,727.65 $1,574.18 $1,446.35 9 10 Down Payment Amount 20,000.00 $ 3,80,000.00$ 36,000.00 $ 11 48,000.00 3,64,000.00 $ $ Loan Amount 3,52,000.00 12 Monthly Payment $1,727.65 $1,574.18 $1,446.35 13 14 15 16 17 18 19 20 21 Sheet2 Sheet3 Sheet1 Select destination and press ENTER or choose Paste 100% 08:31 e ENG 28-10-2019 #