Maths
posted by Marty .
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) total finance charge and b) monthly payment..
Use this partial APR table for finance charge per $100
Payments
Number Annual percentage rate
ofPmts 7.00% 7.50% 8.00% 8.50%
24 7.45 8.00 8.54 9.09
30 9.30 9.98 10.66 11.35
36 11.16 11.98 12.81 13.64
Each entry in the table represents finance charge/$100 at the given terms.

the monthly rate i is .075/12 = .00625
He finances 32,000 dollars, so
32000 = paym[1  1.00625^(36)]/.00625
this gave me a payment of $995.40
his total interest charge is 32000  36*995.40
= $3834.36
If I use your chart, the interest charge would be 11.96*36 = $3833.60 a difference of 76 cents.
I was using the accepted compound interest formula
Present value = paym(1  (1+i)^n)/i 
the interest charge would be 11.96*36 = $3833.60 a difference of 76 cents
Hi how did you get the 3833.6 from multiplying 11.96*36.
Thanks 
sorry, I meant to type 11.98*32000/100 = 3833.60
I think I was thinking of my own calculation. 
Thanks
Respond to this Question
Similar Questions

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
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 … 
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? 
MORTGAGE
Find the monthly payment for the loan. (Round your answer to the nearest cent.) A $128,000 home bought with a 20% down payment and the balance financed for 30 years at 8.5% 
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?