MATH
posted by Roxana .
In order to make some home improvements, a home owner spent $24,000. He paid 18% as a down payment and financed the balance of the purchase with a 36month fixed installment loan with an APR of 4.5%. Determine the home owner's total finance charge and monthly payment

% Financed = 100%  18% = 82%.
Amt. Financed = $24,000 * 0.82 = $19,680.
Pt = Po*r*t / (1  (1+r)^t).
r = 4.5% / 12 = 0.375% = 0.00375 = Monthly % rate expressed as a decimal.
Pt=(19680*0.00375*36)/(1(1.00375)^36,
Pt=2656.80 / 0.126063452 = $21,075.10.
Int.=Pt  Po=21075.10  19680=$1395.10
Monthly Payments=21,075.10 / 36 = $585.42.
Respond to this Question
Similar Questions

Maths
In order to make some home improvements, a home owner spent $40,000. He paid 20% as a down payment and financed the balance of the purchase with a 36month fixed installment loan with an APR of 7.5%. Determine the home ownerâ€™s a) … 
Math
4. Vanna has just financed the purchase of a home for $200 000. She agreed to repay the loan by making equal monthly blended payments of $3000 each at 9%/a, compounded monthly. c. How long will it take to repay the loan? 
Math
The price of a home is $185,000. A down payment of 10% is required with 2 points at the time of closing. The home is financed over a 25 year period with a fixed rate of 4.5%. Find the monthly payment and total interest paid? 
Algebra
A $130,000 home bought with a 20% down payment and the balance financed for 30 years at 7.5% Find the monthly payment for the loan 
Math
Tim Worker buys a new sofa for $549.95. He pays 20% down and takes an installment loan to complete the purchase. He makes 12 payments which include his principal and a $50.00 finance charge. What is the APR on his loan? 
math
Tim Worker buys a new sofa for $629.95. He pays 25% down and takes an installment loan to complete the purchase. He makes 12 payments which include his principal and a $60.00 finance charge. What is the APR on his loan to the nearest … 
math
A carpenter spent $4500 to purchase a table saw , a circular saw, and a panel saw. He paid 5% down and financed the balance with a 30month fixed installment loan with an APR of 5.0%. Determine the total finance charge and monthly … 
Math
A family purchased a new ski boat for $20,000. The loan agency required a down payment and financed the balance for 36 months with an APR of Determine the total finance charge and monthly payment for the loan. 
Finance
A family purchased a new ski boat for $20,000. The loan agency required a down payment and financed the balance for 36 months with an APR of Determine the total finance charge and monthly payment for the loan. 
Finance
Could someone tell me how to calculate this in excel?