Please fill in the blanks (1) ~ (4). Thank you!
The formula to be used is the Present value of ordinary annuity formula |
ie. PV of loan=Pmt.*(1-(1+r)^-n)/r |
where, PV of the loan or borrowings is given as 30 mlns. JPY |
Pmt.= the equal monthly payment to be found out---- ?? |
r= rate of interest, ie.2.4% p.a. ie. 0.20% p.m or 0.002 p.m (for Case 1) & |
3% p.a. Ie. 0.25% p.m or 0.0025 p.m (for Case 2) |
n= no.of compounding periods= 30 yrs.*12 mths.= 360 |
So, now, plugging in all the given values in the above formula, |
Case 1 |
ie. PV of loan=Pmt.*(1-(1+r)^-n)/r |
30=Pmt.*(1-(1+0.0020)^-360)/0.0020 |
Mthly. Pmt.=30/((1-(1+0.0020)^-360)/0.0020) |
0.116982 |
Millions |
Case 2 |
30=Pmt.*(1-(1+0.0025)^-360)/0.0025 |
0.126481 |
Millions |
Answers: |
Case 1-- Monthly common payment, C satisfies $116981 < C < $116983 |
Case 2-- Monthly common payment, C satisfies $ 126480 < C < $ 126482 |
Please fill in the blanks (1) ~ (4). Thank you! On the monthly common payment, Question...
Please fill in the blanks. Assume that you borrow 1 million JPY from some bank and repay under the plan of total equally payment, 8,000 JPY monthly (1) under the system of 6% yearly compound interest, the repayment exit is X (2) under the system of 3% yearly compound interest, the repayment exit is x months (later) months (later)
Fill in the last blank please. (to get the answer, the repay exit is X years later.) <-- I need the X. Thank you! Assume that you borrow 1 million JPY from some bank under the system of 5% yearly compound interest, and repay 80,000 JPY annually under the plan of total equally payment We would like to know the repay exit. you can calculate. 1-inc = First, we calculate the value On the other hand, we fill the following...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your monthly payment? Round your answer to 2 decimal places. 2. You borrow $100,000 on a mortgage loan. The loan requires monthly payments for the next 30 years. Your annual loan rate is 4.25%. The loan is fully amortizing. What is your Month 1 interest payment? Round your answer to...
Question Completion Status QUESTION 4 Your monthly mortgage payment (principal plus interest) is $1,650. you have a 24-year loan with a fixed interost rate of 0.4 % per month, how much did you borrow from the bank to purchase your house (rounded to the nearest whole dolar)? (Do not enter a dollar sign $ with your answer) 15 points QUESTION 15 points Consider the following sequence of year-end cash flows ΕΟΥ 3 Cash Flow What is the uniform annual equivalent...
Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...
(1) What would be the monthly payment for the 30 year monthly mortgage (total 360 equal amount payments) on the house worth three hundred thousand now, if the first payment is due a month from now and the yearly interest rate is (a) r-: 4% compounded monthly, (b) r-4% compounded continuously, (c) r-5% compounded monthly, (d) r--5% compounded continuously. Explain your calculations and box your answers giving nearest integer to the actual answer
answer those 4 please Fatima just borrowed 83,364 dollars. She plans to repay this loan by making a special payment of 29,387 dollars in 7 years and by making regular annual payments of 13,147 dollars per year until the loan is paid off. If the interest rate on the loan is 17.93 percent per year and she makes her first regular annual payment of 13,147 dollars immediately, then how many regular annual payments of 13,147 dollars must Fatima make? Round...
John is looking to borrow $130,000 via a 30 year constant payment mortgage. He given two choices on interest rates, a 5 1/2% rate with 4 points to be included in closing costs, and a 6% rate with 1 point. If John expects to repay the loan after 7 years, which loan should he take? Compare the annual effective interest cost of the two loan alternatives. Show your work.