Question: Quan van on last cel Proust Action Failed 7 - X Gauiy: Karrinkiy - TIOM INSERT PAGE LANCUE TORMULAS DATA RMW MEW Calibri - 11

Quan van on last cel Proust Action Failed 7 - X Gauiy: Karrinkiy - TIOM INSERT PAGE LANCUE TORMULAS DATA RMW MEW Calibri - 11 -A == - Wrap Calculation X. Cut Le Copy Format Pontes Clipboard Normal & Carditional Forma check Cell Formatting Table Bad Good Exploratory... Input Neutral Linked Cell EEE Morge & Conte $% Note It De Formal Autosum. A Fil- Sant Find Fiber Select Eding Font Alignment Number Style Cels D10 A D F 1 Formular w N K L P O 5 T U w Y 1 2 You horrow money on a selfiquidering instalent loan equal payments at the end of each year, each payment is part principal part interest Interest 4 Loan $290,000 $30,170 Per Year 5 Interest Rate 17.8 6 Lite (years! 62 7 Date of Loen January 1, 2020 9 10 use the installment method not straight line 11 Do NOT round any intermediate numbers. 12 DO NOT turn this into a monthly problem, 13 14 a) What is the annual payment? 15 What are the total interest parents? 16 After payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point) 17 di After payments have been made, what percentage of the total principal has been paid found to the nearest percentage point? 18 19 Fedo the problem if the interest rate is 20 2.00% 21 (fra well designed spread this should take 30 secunde) 22 ) What is the annual payment? 24 What are the total interest payments? 25 ) After 3 payments have been made, what percentage of the total interest has been paid found to the nearest persentace point? 26 In After payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point? 27 29 30 31 32 33 34 25 36 37 Q Loan 23992972 + HEAD 100% 1:33 PM W221692 D 0 x
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
