Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Related questions
Question
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
1.-
Osmara Del Toro deposits her life savings working at HoneyBee for $545,000, for when her retirement day arrives in 6 years, 6 months 6 days. The contract stipulates the payment of interest capitalizable quarterly, at a rate of 10.¼ %. What is the amount she will have at the end of the term that will provide welfare in her old age?
Note:
In the image, this is the original exercise, it is in Spanish, but it is easy to understand.
Very important Note:
It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.
Transcribed Image Text:Osmara Del Toro deposita los ahorros de su vida trabajando en HoneyBee por $545,000, para cuando llegue el día de su
jubilación dentro de 6 años, 6 meses 6 días. El contrato estipula el pago de intereses capitalizables cuatrimestralmente, a
una tasa del 10.¼ % ¿Qué cantidad es la que tendrá al final del plazo que aportará bienestar a su vejez?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
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
- Jennifer has a 60-month fixed installment loan, with a monthly payment of $223.04. The amount she borrowed was $11,000.00 at 8.0% APR. A split second after making her 36th payment, Jennifer decided to pay off the remaining balance on the loan. What is the total amount due to pay off the balance? Use the actuarial method. If you use the Finance Charge Table 11.2, page 632, and the "unearned interest formula", page 635, in your textbook to solve this problem, the result will match exactly with one of the answers. If you use a spreadsheet to do the computation, your result will not match exactly with any of the answers, but it will differ only very little (mostly less than $1) from the "correct" answer. $4,788.06 $4,897.69 $4,931.79 $5,063.35arrow_forwardAnswer the Situation below correctly show your complete solution.I already provided the answer I just need the SOLUTION.( Annuities ) Situation: My cousin , Hershey , is newlywed public school teacher who plans for the education of her future children. Initially , at the beginning of each month , 10 000.00 Php was deposited for 8 years in a bank in Orani. At the end of the month , the investment collects 9 % of annual interest and is compounded monthly. After the last deposit , how much is in the account ? Answer: After the last deposit, Hershey's account has 1 398 561.64 Php.arrow_forwardSuppose a recent college graduate's first job allows her to deposit $250 at the end of each month in a savings plan that earns 9%, compounded monthly. This savings plan continues for 11 years before new obligations make it impossible to continue. If the accrued amount remains in the plan for the next 15 years without deposits or withdrawals, how much money will be in the account 26 years after the plan began? (Round your answer to the nearest cent.) $arrow_forward
- SIMPLE INTERESTConstruct a time diagram showing the solution of these obligations.José has a loan with a local bank for $ 3,000.00 with 8% annual interest maturing in 15 months. Also, he owes Carlos $ 1,000.00 with 6% annual interest maturing in 5 months. In addition, I asked Ricardo to buy me a computer that costs $ 1,500.00 knowing that he pays a VAT and also charges me 3% annual interest until I pay him the debt. José makes a new agreement to pay his debt in two payments, a payment of $ 800.00 at 7 months and the rest is canceled at 12 months assuming a yield of 4% per year, taking 12 months as the focal date.arrow_forwardSandy Kupchack just graduated from State University with a bachelor’s degree in history. During her four years at the university, Sandy accumulated $11,500 in student loans. She asks for your help in determining the amount of the quarterly loan payment. She tells you that the loan must be paid back in five years and that the annual interest rate is 8%. Payments begin in three months. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)arrow_forwardSuppose a recent college graduate's first job allows her to deposit $250 at the end of each month in a savings plan that earns 9%, compounded monthly. This savings plan continues for 14 years before new obligations make it impossible to continue. How much money has accrued in the account at the end of the 14 years? (Round your answer to the nearest cent.) $ If the accrued amount remains in the plan for the next 15 years without deposits or withdrawals, how much money will be in the account 29 years after the plan began? (Round your answer to the nearest cent.) $arrow_forward
- Español Leila takes out a loan for her college tuition from a bank that charges simple interest at an annual rate of 6.4%. Her loan is for s5300 for 7 months. Assume each month is of a year. Answer each part below. 圖 Do not round any intermediate computations, and round your final answers to the nearest cent. If necessary, refer to the list of financial formulas. (a) Find the interest that will be owed after 7 months. Assuming Leila doesn't make any payments, find the amount (b) owed after 7 months.arrow_forwardYou have just completed your four-year degree at Southwest Minnesota State University (SMSU)! Your student loans that you have accumulated while studying at SMSU total $25,000. Since you have graduated, you must now begin repaying these student loans. The loan’s annual interest rate is six percent (6%) and it requires four equal end-of-year payments. a) Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. B) What is the total amount that you will repay over this four-year period (principal + interest)? c) What portion or percentage are the total “Interest Payments” of the initial loan value of $25,000?arrow_forwardAnita opens a savings account. At the start of each month she deposits SX into the savings account. At the end of each month, after interest is added into the savings account, the bank withdraws $2500 from the savings account as a loan repayment. Let M be the amount in the savings account after the n" withdrawal. The savings account pays interest of 4.2% per annum compounded monthly. (i) Show that after the second withdrawal the amount in the savings account is given by M = X(1.0035 + 1.0035)- 2500(1.0035 + 1). %3D (ii) Find the value of X so that the amount in the savings account is $80 000 after the last withdrawal of the fourth year.arrow_forward
- Subject: accountingarrow_forwardSuppose a recent college graduate's first job allows her to deposit $250 at the end of each month in a savings plan that earns 9%, compounded monthly. This savings plan continues for 13 years before new obligations make it impossible to continue. If the accrued amount remains in the plan for the next 15 years without deposits or withdrawals, how much money will be in the account 28 years after the plan began? (Round your answer to the nearest cent.)arrow_forwardOn August 1, Rachael Westlake joined a Christmas Club. Her bank will automatically deduct $120 from her checking account at the end of each month and deposit it into her Christmas Club account, where it will earn 67% interest. The account comes to term on December 1. (Round your answers to the nearest cent.) (a) Find the present value of the given annuity. $ X (b) Interpret the present value of the given annuity. You would have to invest a lump sum of $ X now instead of $120 per month.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 Learning
Corporate 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