ZuoTi.Pro
Question

Paul takes a loan of $225,000 from the bank at 7% interest rate per year over...

Paul takes a loan of $225,000 from the bank at 7% interest rate per year over a 10-year period. He plans to pay off the loan in 10 yearly payments of $16,000 each, and with the money that he is going to inherit from his grand parents. How much should he inherit to pay off the entire loan if the grand parents give him the money at the end of the 4th year and he hands over the entire amount to the bank on the day he receives it?

Can you please work in excel adjusting NPER and RATE with PV and FV formulas to find the inheritance needed. Please if you do not know how to do this in the way I'm asking do not copy and paste an already posted solution. Thank You

business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
Paul takes a loan of $225,000 from the bank at 7% interest rate per year over...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 5(a) A company is discussing a $0.5 million loan with a bank. The interest rate is...

    5(a) A company is discussing a $0.5 million loan with a bank. The interest rate is 12% compounded annually and the repayment period is 5 years. The bank is offering two options for loan repayment: Option A: Payments are to be received in equal installments at the end of each year Option B: Interest is to be received on a yearly basis and the Principal is to be received at the end All loan repayment items are end-of-year payments Which...

  • You borrow $1,000 from the bank and agree to repay the loan over the next year...

    You borrow $1,000 from the bank and agree to repay the loan over the next year in 12 equal monthly payments of $90. However, the bank also charges you a loan initiation fee of $29, which is taken out of the initial proceeds of the loan. What is the effective annual interest rate on the loan, taking account of the impact of the initiation fee? You borrow $1,000 from the bank and agree to repay the loan over the next...

  • 1. Complete the following table. Number of Annual Payments or Years Present Value Interest Rate Future...

    1. Complete the following table. Number of Annual Payments or Years Present Value Interest Rate Future Value Annuity 10 $250.00 12% 20 S1,000 25 S500,000 30 S1,000,000 2. You just started working and you planned to save $5,000 every year in your retirement account. How much money will you have in your retirement account once you retire in 40 years? Your retirement account pays 4% interest rate per year. 3. You just retired with S1,000,000 savings. You'd like to receive...

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

  • If your uncle borrows $55,000 from the bank at 9 percent interest over the seven-year life of the loan

    If your uncle borrows $55,000 from the bank at 9 percent interest over the seven-year life of the loan. Use Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. What equal annual payments must be made to discharge the loan, plus pay the bank its required rate of interest? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) How much of his first payment will be applied to interest? To principal? (Do not...

  • An investor can invest money with a particular bank and eam a stated interest rate of...

    An investor can invest money with a particular bank and eam a stated interest rate of 15.40%; however, interest w be compounded quarterly. What are the nominal, periodic, and effective interest rates for this investment opportunity? Interest Rates Nominal rate Periodic rate Effective annual rate Rahul needs a loan and is speaking to several lending agencies about the interest rates they would charge and the terms they offer. He particularly likes his local bank because he is being offered a...

  • An amount of $15,000 is borrowed from the bank at an annual interest rate 12% h...

    An amount of $15,000 is borrowed from the bank at an annual interest rate 12% h Calculate the repavment amounts if the loan ($15 000) will be repaid in two equal installments of $7.500 each, paid at the end of second and fourth years respectively. Interest will be paid each year Click the icon to view the interest and annuity table for discrete compounding when i- 12%% per year . a. The equal end-of-year payments required to pay off the...

  • NP 631500,00 10 year simple interest 0.1275 requires payment at least 75000.00 per year for over...

    NP 631500,00 10 year simple interest 0.1275 requires payment at least 75000.00 per year for over 12 months You are free to make any payments at any time. however any payments received will be applied first to interest accrued and only when interest is paid off to the principal Regardless of payments, the entire loan must be paid off with all accrued interest by june 1, 2029. You make first payment march 1 2020, 75000. No further payments are made...

  • You borrow $1,000 from the bank and agree to repay the loan over the next year...

    You borrow $1,000 from the bank and agree to repay the loan over the next year in 12 equal monthly payments of $90. However, the bank also charges you a loan initiation fee of $28, which is taken out of the initial proceeds of the loan. What is the effective annual interest rate on the loan, taking account of the impact of the initiation fee? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal...

  • 4. You are about to borrow $16,000 from a bank at an interest rate of 7%...

    4. You are about to borrow $16,000 from a bank at an interest rate of 7% compounded annually. You are required to make five equal repayments in the amount of $3,500 per year, with the first repayment occurring at the end of year 1. a. Show the interest payment and principal payment in each year. b. How much is still owing at the end of year 5? c. What annual payments would be required to completely pay off the loan...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT