MyFinanceLab With eText - Access (Custom Package)
15th Edition
ISBN: 9781269945684
Author: Pearson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5.5P
Sub part (a)
Summary Introduction
To calculate:
Introduction:
Future value (FV): The future value refers the value of present amount at a future date.
Sub part (b)
Summary Introduction
To calculate: Interest earned.
Sub part (c)
Summary Introduction
To discuss: Comparison of future value in and interest earned.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Answer in excel2. Suppose another graduating student also has a financial plan with regard to starting his business. He intends to borrow $25,000 from his family and friends at the end of this year to start his business. He believes his business will earn $5000 after expenses one year after it begins, another $7000 after expenses the following year, $10,000 after expenses in each of the next , two years, and $3000 in the last year before it closes. Using a 4% annual interest discount rate, determine the net present value of this investment.
QUESTION 5 Please use excel
Robert has borrowed $339,000 to purchase a house in the current year at 5.5% interest rate, with a commitment to repay the loan (principal and interest) in equal annual instalments over the following 15 years. Calculate the:
a) the yearly annuity payment is = $
b) the amount of the principal repayment in year 2 is = $
c) total amount of interest paid = $
d) if the interest rate decreases to 3% the total amount paid over the life of the loan would be = $
Provide your answers to 2 decimal places. Show all your working in your spreadsheet.
H5.
A loan of X is repaid with level annual payments at the end of each year for 10 years. You are given: The interest paid in the first year is 3,600 The principal repaid in the sixth year is 4,871. Calculate X.
Show proper step by step calculation
Chapter 5 Solutions
MyFinanceLab With eText - Access (Custom Package)
Ch. 5.1 - What is the difference between future value and...Ch. 5.1 - Define and differentiate among the three basic...Ch. 5.2 - Prob. 5.3RQCh. 5.2 - Prob. 5.4RQCh. 5.2 - Prob. 5.5RQCh. 5.2 - Prob. 5.6RQCh. 5.2 - Prob. 5.7RQCh. 5.3 - What is the difference between an ordinary annuity...Ch. 5.3 - What are the most efficient ways to calculate the...Ch. 5.3 - How can the formula for the future value of an...
Ch. 5.3 - Prob. 5.13RQCh. 5.3 - Prob. 5.14RQCh. 5.4 - How do you calculate the future value of a mixed...Ch. 5.5 - What effect does compounding interest more...Ch. 5.5 - Prob. 5.21RQCh. 5.5 - Differentiate between a nominal annual rate and an...Ch. 5.5 - Prob. 1FOECh. 5.6 - Prob. 1FOPCh. 5.6 - How can you determine the size of the equal,...Ch. 5.6 - Prob. 5.27RQCh. 5.6 - How can you determine the unknown number of...Ch. 5 - Learning Goals 2, 5 ST5-1 Future values for...Ch. 5 - Prob. 5.3STPCh. 5 - Learning Goal 6 ST5-4 Deposits needed to...Ch. 5 - Assume that a firm makes a 2,500 deposit into a...Ch. 5 - Prob. 5.2WUECh. 5 - Prob. 5.3WUECh. 5 - Your firm has the option of making an investment...Ch. 5 - Joseph is a friend of yours. He has plenty of...Ch. 5 - Jack and Jill have just had their first child. If...Ch. 5 - Prob. 5.1PCh. 5 - Learning Goal 2 P5-2 Future value calculation...Ch. 5 - Prob. 5.3PCh. 5 - Prob. 5.4PCh. 5 - Prob. 5.5PCh. 5 - Learning Goal 2 P5- 6 Time value As part of your...Ch. 5 - Learning Goal 2 P5-7 Time value you can deposit...Ch. 5 - Learning Goal 2 P5-8 Time value Misty needs to...Ch. 5 - Prob. 5.9PCh. 5 - Prob. 5.10PCh. 5 - Prob. 5.11PCh. 5 - Prob. 5.12PCh. 5 - Prob. 5.13PCh. 5 - Prob. 5.14PCh. 5 - Prob. 5.15PCh. 5 - Prob. 5.16PCh. 5 - Cash flow investment decision Tom Alexander has an...Ch. 5 - Learning Goal 2 P5-18 Calculating deposit needed...Ch. 5 - Future value of an annuity for each case in the...Ch. 5 - Present value of an annuity Consider the following...Ch. 5 - Prob. 5.21PCh. 5 - Learning Goal 3 P5-22 Retirement planning Hal...Ch. 5 - Learning Goal 3 P5-23 Value of a retirement...Ch. 5 - Prob. 5.24PCh. 5 - Learning Goal 2, 3 P5-25 Value of an annuity...Ch. 5 - Prob. 5.26PCh. 5 - Prob. 5.27PCh. 5 - Prob. 5.28PCh. 5 - Prob. 5.29PCh. 5 - Prob. 5.30PCh. 5 - Prob. 5.31PCh. 5 - Prob. 5.32PCh. 5 - Prob. 5.33PCh. 5 - Prob. 5.34PCh. 5 - Prob. 5.35PCh. 5 - Prob. 5.36PCh. 5 - Prob. 5.37PCh. 5 - Prob. 5.38PCh. 5 - Prob. 5.39PCh. 5 - Prob. 5.40PCh. 5 - Learning Goals 3, 5 P5-42 Annuities and...Ch. 5 - Prob. 5.42PCh. 5 - Prob. 5.43PCh. 5 - Prob. 5.44PCh. 5 - Prob. 5.45PCh. 5 - Prob. 5.46PCh. 5 - Prob. 5.47PCh. 5 - Loan amortization schedule Joan Messineo borrowed...Ch. 5 - Prob. 5.49PCh. 5 - Prob. 5.50PCh. 5 - Prob. 5.51PCh. 5 - Prob. 5.52PCh. 5 - Prob. 5.53PCh. 5 - Prob. 5.54PCh. 5 - Prob. 5.55PCh. 5 - Prob. 5.56PCh. 5 - Prob. 5.57PCh. 5 - Number of years needed to acccumulate a future...Ch. 5 - Prob. 5.59PCh. 5 - Prob. 5.60PCh. 5 - Time to repay Installment loan Mia Saito wishes to...Ch. 5 - Prob. 5.62P
Knowledge Booster
Similar questions
- Question content area top Part 1 (Related to Checkpoint 6.1) (Future value of an annuity) Imagine that Homer Simpson actually invested the $ 160,000 he earned providing Mr. Burns entertainment 10 years ago at 11 percent annual interest and that he starts investing an additional $ 1,800 a year today and at the beginning of each year for 15 years at the same 11 percent annual rate. How much money will Homer have 15 years from today? Question content area bottom Part 1 The amount of money Homer will have 15 years from now is $ enter your response here . (Round to the nearest cent.)arrow_forward3. Need help with finance homework. Assume a discount rate of 6.75%. You are planning to receive payments annually (at end of year) for the next 6 years. The first payment's amount will be $12,000. Each subsequent payment will increase by 2.2%. What is the present value of these payments you are planning to receive?arrow_forward6. After graduation, you and a few business partners begin a small business. The first year, earn a profit of $10,000. Your profit increases by 12% each year. As a team, you and your business partners have decided to invest all of your profits into an account that you will use to fund a business expansion. Money in the account earns 6% compound annual interest. Use this information to answer the following questions. a. How much would be available in the account at the end of 10 years to fund business expansion? (please explain how to solve this in steps using formulas and showing how :)arrow_forward
- COMPOUND INTEREST PROBLEM1. Find the present value of ₱6,800 due in 5 years if money is worth a. 12% compounded annually. b. 12% compounded semiannually. c. 12% compounded quarterly. d. 12% compounded monthly. 2. Find the present value of ₱12,000 due at the end of 41/2 years if money is invested at 18% converted semiannually. 3. A laptop computer was bought on installment basis: ₱10,000 down payment and the balance of ₱60,000 to be paid in 2 years. What is its cash value if the interest rate is 20% compounded quarterly? 4. The buyer of an automobile pays a ₱150,000 down payment and the balance of ₱500,000 to be paid two years later. What is the cash price of the automobile if money is worth 12% converted annually? 5. If ₱13,000 is due on Dec. 2, 2013, find its present value on June 2, 2010 if money was invested at 10% compounded semiannually.arrow_forwardQuestion 1 You borrow $50,000 for 5 years. This is an amortized load, meaning that payments are the same each month, and the loan is fully paid off with final payment. The quoted interest rate (or APR) is 12% per year. What is the beginning balance, Payment, Interest, Principal and Ending Balance in months 10 and 25? Enter all the necessary information in an Excel spreadsheet as the example in class, by entering the right formulas in each column. Also copy and paste the final table from Excel in a word document and attach it with your answer.arrow_forwardProblem 7-31 Use a financial calculator or a program such as Excel to answer the questions. Round your answers to the nearest whole number. You purchase a stock for $11,000 and collect $600 at the end of each year in dividends. You sell the stock for $12,400 after five years. What was the annual return on your $11,000 investment? % You purchase a building for $920,000, collect annual rent (after expenses) of $130,000, and sell the building for $1,000,000 after six years. What is the annual return on this investment? % You buy a stock for $1,000 and expect to sell it for $900 after five years but also expect to collect dividends of $130 a year. Calculate the return on this investment and prove that it is less than 14 percent. %arrow_forward
- Please show in excel 2. Suppose another graduating student also has a financial plan with regard to starting his business. He intends to borrow $25,000 from his family and friends at the end of this year to start his business. He believes his business will earn $5000 after expenses one year after it begins, another $7000 after expenses the following year, $10,000 after expenses in each of the next , two years, and $3000 in the last year before it closes. Using a 4% annual interest discount rate, determine the net present value of this investment. 3. You have just received an email inviting you to accept a new credit card that offers you a $12,000 credit limit based upon your FICO score. You realize you can use that card now to charge your long overdue upscale vacation, which will cost $7500. The introductory terms of your new card indicates that no payment is due for the next two years, and the amount due will be charged a low 3% every month until you repay. Assuming you wait the full…arrow_forward5. Create an interest calculator that takes input of initial balance and calculates the account balance after the first, second, third and fourth year. The account earns 5 per cent interest per year.arrow_forwardf4. Subject :- Accounting What is the future value in 5 years of a $7,000 investment placed into a bank account today that will pay you 12% interest compounded quarterly? What is the present value of an investment that will pay you $1500/year forever? Use i=9% What is the present value of an investment that will pay you $2500/year forever? Use i=6%arrow_forward
- a principal amount of $600 was invested at 5% interest. in this lesson, recalculate the interest earned and value of the account, this time calculating the next year's interest on the entire value of the account (including previously earned interest), rather than just on the principal amount. Compute the amount of interest earned during the second year if that amount is 5% of both the principal amount of $600 AND the $30 in interest that was already earned in the first year. Find the new ending value as well. Show work, please.arrow_forwardSUBJECT: ENGINEERING ECONOMICS (a) Identify the Given and the Unknown or what is being asked in the problem (b)Provide the formula to be used (c)Show the complete solution. The final answer is already provided. Maria loaned an amount of 100,000Php payable in 15 equal quarterly instalments. The first payment was made a year after the money was borrowed. How much in each quarterly installments if rate of interest is 10% compounded bi-monthly?Answer: A = 8,706.61Phparrow_forwardNeed help with finance homework. 4 Assume that today you invested $120,000 in an investment that you expect will return $260,000 to you in 8 years. Over the next 8 years, what annual interest rate are you expecting to earn?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education