Question

In: Finance

A mobile home worth $56,000 is purchased with a down payment of $6,000 and monthly month-end...

A mobile home worth $56,000 is purchased with a down payment of $6,000 and monthly month-end payments for 15 years. If the interest rate is 9% per annum compounded monthly, determine the balance just after the 10th payment, in 2 decimal places.

Solutions

Expert Solution

Mobile home worth = $ 56000

Down payment = $ 6000

Balance Due amount = $ 56000 - $ 6000 = $ 50000

Interest rate per year = 9 %

interest rate per month = 9 % / 12 = 0.75 % or 0.0075

No. of months = 15 years * 12 = 180 months

Particulars Amount
Balance Due Amount $ 50,000.00
Int rate per Month 0.7500%
No. of Months 180

Equal monthly payment = Balance Due Amount / PVAF (r%, n)
Where r is Int rate per Month & n is No. of Months
= $ 50000 / PVAF (0.0075 , 180)
= $ 50000 / 98.5934
= $ 507.13
Equal monthly payment = $ 507.13

PV Annuity Factor = [ 1 - [(1+r)^-n]] /r
= [ 1 - [(1+0.0075)^-180]] /0.0075
= [ 1 - [(1.0075)^-180]] /0.0075
= [ 1 - [0.26055]] /0.0075
= [0.73945]] /0.0075
= 98.5934

Period Opening Bal Monthly payment Int Principal Repay Closing Outstanding
1 $             50,000.00 $             507.13 $                375.00 $                132.13 $                49,867.87
2 $             49,867.87 $             507.13 $                374.01 $                133.12 $                49,734.74
3 $             49,734.74 $             507.13 $                373.01 $                134.12 $                49,600.62
4 $             49,600.62 $             507.13 $                372.00 $                135.13 $                49,465.49
5 $             49,465.49 $             507.13 $                370.99 $                136.14 $                49,329.35
6 $             49,329.35 $             507.13 $                369.97 $                137.16 $                49,192.19
7 $             49,192.19 $             507.13 $                368.94 $                138.19 $                49,053.99
8 $             49,053.99 $             507.13 $                367.90 $                139.23 $                48,914.77
9 $             48,914.77 $             507.13 $                366.86 $                140.27 $                48,774.49
10 $             48,774.49 $             507.13 $                365.81 $                141.32 $                48,633.17
11 $             48,633.17 $             507.13 $                364.75 $                142.38 $                48,490.78
12 $             48,490.78 $             507.13 $                363.68 $                143.45 $                48,347.33

Balance after 10th Payment = $ 48,633.17

Please comment if any further explanation is required.


Related Solutions

A mobile home worth $41,000 is purchased with a down payment of $6,000 and monthly month-end...
A mobile home worth $41,000 is purchased with a down payment of $6,000 and monthly month-end payments for 15 years. If the interest rate is 9% per annum compounded monthly, determine the balance just after the 10th payment, in 2 decimal places.
A home is purchased for 395,000 with a 10% down payment and a 30 year amortized...
A home is purchased for 395,000 with a 10% down payment and a 30 year amortized mortgage charging 3.6% compounded monthly find: a) the amount borrowed, b) the size of the monthly mortgage payment and c) the total interest paid over 30 years?
You're prepared to make monthly payment of $240, beginning at the end of this month, into...
You're prepared to make monthly payment of $240, beginning at the end of this month, into an account that pays 10 percent interest compounded monthly. How many payments will you have made when your account balance reaches, $35,000?
Patricia purchased a home on January 1, 2017 for $1,250,000 by making a down payment of...
Patricia purchased a home on January 1, 2017 for $1,250,000 by making a down payment of $100,000 and financing the remaining $1,150,000 with a 30-year loan, secured by the residence, at 6 percent. During 2017-2019, Patricia made interest-only payments on the loan of $69,000. What amount of the $69,000 interest expense that Patricia paid during 2019 may she deduct as an itemized deduction? a - $0 b - $9,000 c - $60,000 d - $69,000
Rick Rueta purchased a $88,000 home at 7.5% for 30 years with a down payment of...
Rick Rueta purchased a $88,000 home at 7.5% for 30 years with a down payment of $25,000. His annual real estate tax is $1,932 along with an annual insurance premium of $1,092. Rick’s bank requires that his monthly payment include an escrow deposit for the tax and insurance. What is the total payment each month for Rick? (Round your answer to the nearest cent.)
Jessica purchased a home on January 1, 2018 for $580,000 by making a down payment of...
Jessica purchased a home on January 1, 2018 for $580,000 by making a down payment of $230,000 and financing the remaining $350,000 with a 30-year loan, secured by the residence, at 6 percent. During 2018 and 2019, Jessica made interest-only payments on this loan of $21,000 (each year). On July 1, 2018, when her home was worth $580,000 Jessica borrowed an additional $145,000 secured by the home at an interest rate of 8 percent. During 2018, she made interest-only payments...
A car may be purchased with $3,500 down payment now and 72 monthly payments of $489....
A car may be purchased with $3,500 down payment now and 72 monthly payments of $489. If the interest rate is 9% per year compounded monthly, what is the price of the car?
XYZ has an investment worth $56,000. The investment will make aspecial, extra payment of X...
XYZ has an investment worth $56,000. The investment will make a special, extra payment of X to XYZ in 2 years from today. The investment also will make regular, fixed annual payments of $12,000 to XYZ with the first of these payments made to XYZ in 1 year from today and the last of these annual payments made to XYZ in 5 years from today. The expected return for the investment is 13.2 percent per year. What is X, the...
XYZ has an investment worth $56,000. The investment will make a special, extra payment of X...
XYZ has an investment worth $56,000. The investment will make a special, extra payment of X to XYZ in 3 years from today. The investment also will make regular, fixed annual payments of $12,000 to XYZ with the first of these payments made to XYZ in 1 year from today and the last of these annual payments made to XYZ in 5 years from today. The expected return for the investment is 13.2 percent per year. What is X, the...
Judy recently purchased her first home for $220,000. She made a down payment of $20,000, and...
Judy recently purchased her first home for $220,000. She made a down payment of $20,000, and financed the balance over 15 years, at 6% interest. How much is her principal and interest payment each month?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT