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?

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?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 1E

See similar textbooks

Similar questions

Megan invests $1, 500 at the end of each year into an account earning 2% effective annual interest. She reinvests the interest earned at the end of each year into a second account that will earn her 8% effective annual interest. How much is in the second account after 30 years? Also, fill in the following table (or, redraw the table on your solution sheet being handed in and fill it in
Example: In this exercise prepare an amortization schedule showing the payments for each loan. Joan Varozza plans to borrow $20,000 to stock her small boutique. She will repay the loan with semiannual payments for 5 years at 7% interest. SET UP AN AMORTIZATION TABLE
After retirement, you expect to live for 25 years. You would like to have a $95,000 income each year. The annual interest rate is 9 percent per year. Required: Calculate the amount of savings you have in your retirement account to receive this income. 1 Assume that the payments start on the day of your retirement. 2.Assume that the payments start one year after the retirement.
To help buy her new condominium, Mai is taking out a $163,000 mortgage loan for 30 years at 3.4% annual interest. Her monthly payment for this loan is $722.87. of a year. Round your answers to the nearest cent. 12 Fill in all the blanks in the amortization schedule for the loan. Assume that each month is Payment number Principal payment Interest New loan balance payment 1 2 $| $162,477.18 130 $346.85 $376.02 $122,041.32 $ 0 131
Carol Travis started a paper route on January 1, 2020. Every three months, she deposits $1,050 in her bank account, which earns 8 percent annually but is compounded quarterly. On December 31, 2023, she used the entire balance in her bank account to invest in a contract that pays 6 percent annually. How much will she have on December 31, 2026? (Use a Financial calculator to arrive at the answer. Round "FV Factor" to 3 decimal places. Round your intermediate and final answer to the nearest whole dollar.) Future value
After retirement, you expect to live for 25 years. You would like to have a $95,000 income each year. The annual interest rate is 9 percent per year. Required: Calculate the amount of savings you have in your retirement account to receive this income. A) Assume that the payments start on the day of your retirement. B) Assume that the payments start one year after the retirement.
Answer the given problem. Problem: Mrs Talla obtained a loan of P200,000. She has to repay the loan by equal payments at the end of every six months for 5 years at 2% interest compounded semi-annually. Find the periodic payment. (Prepare an amortization schedule) The given picture is only a sample of amortization schedule please refer to it. Thank you.
A). Sun will be starting a 5-year training program in 23 months’ time. His mother, Moon, has promised him a living allowance of $167.2 per month to help support him during this time. If the interest rate is 9.3 percent per annum, compounded monthly, how much money will Moon need to set aside today to finance Sun’s allowance? Round your answers to two decimal points for all stages of calculation B). A loan amount of $26,044 will be due after 8 years. Tim has a deposit plan to deposit $5,543 at the beginning of each year for the next 8 years. The deposit rate is 10% per annum. Find the deficit or surplus amount from this deposit plan to repay the total loan amount after 8 years if the interest is being compounded monthly. Round your answers to 2 decimal points. C). Your investment in A Limited earned the following returns for the years 1996 to 1999: 30%, 40%, 15% and 7%. What is the variance of returns for this investment? Round your answer to 4 decimal points.
Sam takes out a loan for $3,685.50. The term of the loan is 7 years, and she will make bi-weekly payments. The interest rate on the loan is 3.475% compounded monthly. a) What is the effective interest rate per payment period? b) If Sam is going to repay the loan with level payments, what is the monthly payment amount? c) Fill in the first 3 rows of the loan amortization table. d) What would the nominal interest rate (compounded monthly) have to be if the bi-weekly (level) payment amounts were $24.69?
Kylie takes out a $12,500 loan on May 1, 2023, to be re-paid over 5.5 years, with the first payment at the end of that month. For the first 2 years, interest is charged at an annual rate of 4%. After that, the annual interest rate increases to 5.4%. What monthly payment is needed to ensure the loan is paid in time?
Zach Taylor is settling a $20,000 loan due today by making 6 equal annual payments of $4,727.53. Determine the interest rate on this loan, if the payments begin one year after the loan is signed.
You decide to open a retirement account at your local bank that pays 8%/year/month (8% per year compounded monthly). For the next 20 years you will deposit $400 per month into the account, with all deposits and withdrawals occurring at the end of the month. On the day of the last deposit, you will retire. Your expenses during the first year of retirement will be covered by your company’s retirement plan. As such, your first withdrawal from your retirement account will occur on the day exactly 12 months after the last deposit.