You need to heave $34,500 in 14 years. You can earn an annual interest rate of 5 percent for the first 4 years, 5.6 percent for the next 3 years, and 6.3 percent for the final 7 years. How much do you have to deposit today? MUST USE EXCEL FORMULAS!! NOT ALGEBRAICALLY!

You need to heave $34,500 in 14 years. You can earn an annual interest rate of 5 percent for the first 4 years, 5.6 percent for the next 3 years, and 6.3 percent for the final 7 years. How much do you have to deposit today? MUST USE EXCEL FORMULAS!! NOT ALGEBRAICALLY!

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 3PB: Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate...

See similar textbooks

Related questions

Q: You want to have $40,000 in your savings account 6 years from now, and you're prepared to make equal…

A: The concept of time value of money will be used here and that of annuities. The amount of $40,000 is…

Q: You've been offered a loan of $20000, which you will have to repay in 5 equal annual payments of…

A: Present Value = pv = $20,000Number of Payment = n = 5Payment = p = $6000

Q: Suppose you have $2,100 and plan to purchase a 10-year certificate of deposit (CD) that pays 13.1%…

A: Value when the CD matures = 2100 x (1 + 0.131)^10 = $7191.93

Q: You wish to have $15,000 dollars in 4 years. How much do you need to deposit today if the rate is…

A: A method of computing interest amounts in which the compounding effect was not considered by the…

Q: You deposit $100 today, $200 one year from now, and $300 three years from now. How much money will…

A: The concept of the time value of money states that the same amount of money today is worth more than…

Q: You want to be able to withdraw $50,000 each year for 25 years. Your account earns 9% interest. a)…

A: An annuity is a payment series that provides its holder with a periodic amount in exchange for a…

Q: (2) You have $9, 500 you want to invest. Your bank has several investment accounts to choose from,…

A: Compounding is the concept of interest calculation when interest on interest is also accumulated in…

Q: You have decided to start a savings plan for your retirement. You plan to make an annual deposit of…

A: The objective of the question is to calculate the future value of a series of annual deposits of…

Q: You borrow $155,000; the annual loan payments are $12, 490.89 for 30 years. What interes rate are…

A: Borrowed amount = $155,000Annual loan payment = $12,490.89Number of years = 30 Years

Q: a. You need $17,000 in five years but you only have $12,000 now. At what interest rate must you…

A: As per guidelines, I am supposed to answer 1 question at a time. As the question is not specifically…

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Andres Rosas wants to know how much…

A: Discounting is a technique through which present value (PV) of future cashflows is computed by using…

Q: 13) You take out a loan for $75,000 for 12 years at 6% monthly. What is the payment? a) how much…

A: A study that proves that the future worth of the money is lower than its current value due to…

Q: You have decided to start a savings plan for your retirement. You plan to make an annual deposit of…

A: The objective of the question is to calculate the future value of a series of annual deposits of…

Q: The bank balance will be $

A: Time value of money (TVM) means that the amount of money received in the present times will have…

Q: Suppose that you're planning a vacation and borrow $2,000 from a bank for one year at a stated…

A: The real interest that an investor earns on the investment and a borrower pays on loan after…

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

You need to have $30,000 for a down payment on a house in 6 years. If you can earn an annual interest rate of 3.3 percent, how much will you have to deposit today? USE EXCEL FORMULAS ONLY! NO ALGEBRAICALLY!
You need to have $34,500 in 14 years. You can earn an annual interest rate of 5 percent for the first 4 years, 5.6 percent for the next 3 years, and 6.3 percent for the final 7 years. How much do you have to deposit today? MUST USE EXCEL FORMULA, NOT ALGEBRAICALLY!
Suppose that you borrow $200,000 in the form of a 12-year loan with an annual interest rate of 6% with monthly payments and monthly compounding. How much principal will you pay in the last year of the loan? Please describe how to solve using a financial calculator thank you.
Suppose that you wish to buy a new home that will cost you $452,847. You must put $80,000 down, and the bank offers you a 5-year 5.1% APR negative amortization loan with a payments $1,258 per month, and a balloon payment of $92,233 (your 360th payment). How much will your remaining payments be?
Please provide the steps to solving this problem using a financial calculator: You just opened a brokerage account, depositing $3,500. You expect the account to earn an interest rate of 9.652%. You also plan on depositing $4,500 at the end of years 5 through 10. What will be the value of the account at the end of 20 years, assuming you earn your expected rate of return?
Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
You put $250 in the bank for S years at 12%. A. If interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. B. Use the future value of $1 table in Appendix B and verity that your answer is correct.
You put $600 in the bank for 3 years at 15%. A. If Interest Is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.
Suppose you take out a $117,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 5%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 3%, what is the real value of the first (year-end) payment? g. If the inflation rate is 3%, what is the real value of the last (year-end) payment? h. Now assume the inflation rate is 6% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? i-1. Recompute the amortization table. i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last…
Assume you graduate from college with $26,000 in student loans. If your interest rate is fixed at 5.00% APR with monthly compounding and you repay the loans over a 10-year period, what will be your monthly payment? (Note: Be careful not to round any intermediate steps less than six decimal places.) Your monthly payment will be $_____ (Round to the nearest cent.)