Question
In: Accounting
The monthly payment on a 900,000 , 20 yr. mortgage at 5.75% is $6,318.75 per month. How much of that 900,000 on day 1 is deemed to be "current portion of mortgage payable"?
The monthly payment on a 900,000 , 20 yr. mortgage at 5.75% is $6,318.75 per month. How much of that 900,000 on day 1 is deemed to be "current portion of mortgage payable"?
Solutions
Expert Solution
| Note: since question is asking for current portion of mortgage | |||
| payable on day 1 , so on day 1 only principal payment payable | |||
| withing 1-12 months period is relevant | |||
| Using the excel cumprin formula | |||
| PV | 900000 | ||
| Rate | 0.4792% | (5.75%/12) | |
| NPER | 240 | (20 x 12) | |
| Start period | 1 | ||
| End period | 12 | ||
| Cumprinc | $ (24,718.62) | ||
| =CUMPRINC(0.4792%,240,900000,1,12,0) | |||
| So current portion of mortgage payable on day 1 will be $24,718.62 | |||
ekkarill92 answered 2 years agoRelated Solutions
1: The monthly payment on a 900,000 , 20 yr. mortgage at 5.75% is $6,318.75 per...
1: The monthly payment on a 900,000 , 20 yr. mortgage at 5.75%
is $6,318.75 per month. How much of that 900,000 on day 1 is deemed
to be "current portion of mortgage payable"?
2: Explain the difference between straight-line method of
amortization a bond discount as opposed to using the effective
interest method of amortizing a bond discount.
3: Why does a Bond sell at a discount? Why would a Bond sell
at a premium?
1: The monthly payment on a 900,000 , 20 yr. mortgage at 5.75% is $6,318.75 per...
1: The monthly payment on a 900,000 , 20 yr. mortgage at 5.75%
is $6,318.75 per month. How much of that 900,000 on day 1 is deemed
to be "current portion of mortgage payable"?
2: Explain the difference between straight-line
method of amortization a bond discount as opposed to using the
effective interest method of amortizing a bond discount.
3: Why does a Bond sell at a discount?
Why would a Bond sell at a premium?
A family took a 20 year mortgage of $195,000 at 5.75% per year compounded monthly. Immediately...
A family took a 20 year mortgage of $195,000 at 5.75% per year
compounded monthly. Immediately after the 85th monthly payment,
they decided to re-finance this mortgage because they found a lower
rate of 3.75% per month compounded monthly. If they continue the
same amount of monthly payments as before, how long will it take to
pay off this mortgage?
A family took a 20 year mortgage of $195,000 at 5.75% per year compounded monthly. Immediately...
A family took a 20 year mortgage of $195,000 at 5.75% per year
compounded monthly. Immediately after the 85th monthly payment,
they decided to re-finance this mortgage because they found a lower
rate of 3.75% per month compounded monthly. If they continue the
same amount of monthly payments as before, how long will it take to
pay off this mortgage?
What is the monthly payment for a 30-year mortgage with a 3.00% APY? How much of...
What is the monthly payment for a 30-year mortgage with a 3.00%
APY? How much of the first payment goes toward reducing the
principal amount owed?
How much will you pay on a 25 year, $400,000 mortgage if you make monthly payment...
How much will you pay on a 25 year, $400,000 mortgage if you
make monthly payment at the beginning of month? Interest is 3.5%.
Answer is $1,997
What will be the monthly payment on a $75,000 30-year home mortgage at 1% interest per...
What will be the monthly payment on a $75,000 30-year home
mortgage at 1% interest per month?
You obtained a home mortgage of $85,000 for 20 years at 4.5% compounded monthly. How much...
You obtained a home mortgage of $85,000 for 20 years at 4.5%
compounded monthly. How much is your monthly payment.
How much money is required now to provide an income of $1,600 per month for six years if the money earns interest at 6% p.a. compounding monthly and the first $1,600 payment is payable 2 years from today?
How much money is required now to provide an income of $1,600 per
month for six years if the money earns interest at 6% p.a.
compounding monthly and the first $1,600 payment is payable 2 years
from today?
Case 1: You apply for a 20-year, fixed-rate (APR 6.48%) monthly-payment-required mortgage loan for a house...
Case 1: You apply for a 20-year, fixed-rate (APR 6.48%)
monthly-payment-required mortgage loan for a house selling for
$150,000 today. Your bank requires 22% initial down payment of
house value (to be paid upfront in cash immediately, thus not
included in the loan balance), and $3,000
application-process-closing cost (to be carried into the beginning
loan balance and amortized later).
(a) What is your monthly loan payment if you stick to the
mortgage deal till the end (assuming each payment is...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
- Toady and Froggy were running a vegan cafe together. The business was having financial difficulties.Betelguese, who...
- 1. The following questions concern Jesse Gelsinger who suffered from partial OTC. a. In the...
- Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales...
- TzeMay was one of the first women engineering students at ABC University. She graduated in 1995...
- Use the following information to calculate these various solvency measures: a) NWC, B) WCR, c) Current...
- The files SpeedControl.java and SpeedControlPanel.java contain a program (and its associated panel) with a circle that...
ADVERTISEMENT