please help with how to do calculation within excel Carol Travis started a paper route on January 1, 2020. Every three months, she deposits $500 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 9 percent annually.How much will she have on December 31, 2026

please help with how to do calculation within excel Carol Travis started a paper route on January 1, 2020. Every three months, she deposits $500 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 9 percent annually.How much will she have on December 31, 2026

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter9: Current Liabilities, Contingencies, And The Time Value Of Money

Section: Chapter Questions

Problem 9.7P

See similar textbooks

Similar questions

Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
Refer to the present value table information on the previous page. What amount should Brett have in his bank account today, before withdrawal, if he needs 2,000 each year for 4 years, with the first withdrawal to be made today and each subsequent withdrawal at 1-year intervals? (Brett is to have exactly a zero balance in his bank account after the fourth withdrawal.) a. 2,000 + (2,000 0.926) + (2,000 0. 857) + (2,000 0.794) b. 2,0000.7354 c. (2,000 0.926) + (2,000 0.857) + (2,000 0.794) + (2,000 0.735) d. 2,0000.9264
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
Trina opened a deposit account on December 1, 2016 with a deposit of $5 000. She added $2000.00 on September 1 2018 and will add $ 6000 on December 1, 2023. How much will be in the account on June 1, 2024 if the deposit earns 12% compounded monthly?
On May 11, Ali joined a gulf club. His bank will automatically deduct BD 120 from his checking account at the end of each month, and deposit it into his gulf club account, where it will earn 8% annual interest. The account comes to term on October 7. Find the following: a. Find the future value of Ali's gulf club account. b. Find Ali's total contribution to the account. C. Find the total interest earned on the account.
Kelly Jones and Tami Crawford borrowed $26,000 on a 7-month, 6% note from Gem State Bank to open their business, Pharoah’s Coffee House. The money was borrowed on June 1, 2022, and the note matures January 1, 2023. what is the entry required on January 1, 2023, when the loan is paid back?
On March 12, Nada joined a saving account. Her bank will automatically deduct BD 200 from her checking account at the end of each month, and deposit it into her saving account, where it will earn 5 % annual interest. The account comes to term on December 1. Find the following: a. Find the future value of Nada’s saving account. b. Find Nada’s total contribution to the account. c. Find the total interest earned on the account.
Your father offers to give you $400 on January 1, 2019. You will then make six additional equal payments each 6 months from July 2019 through January 2022. If your bank pays 8% compounded semiannually, how large must each payment be for you to end up with $1,000 on January 1, 2022? What is the Effective Annual Rate (EAR) earned on the bank account in part f? What is the Nominal Interest Rate or Annual Percentage Rate (APR) earned on the account?
On March 12, Nada joined a saving account. Her bank will automatically deduct BD 200 from her checking account at the end of each month, and deposit it into her saving account, where it will earn 5 % annual interest. The account comes to term on December 1. Find the following: a. Find the future value of Nada’s saving account. b. Find Nada’s total contribution to the account. c. Find the total interest earned on the account. a. a.1899 b.1800 c. 99 BD b. a.1949 b.1900 c. 49 BD c. a.1149 b.1100 c. 49 BD d. a.1829 b.1800 c. 29 BD e. a.2839 b.2800 c. 39 BD
Dillion Savage decides to make semiannual $5000 deposits into an account that pays 5% compounded semiannually. If his first deposit is on January 1, 2021, then how much is in the account immediately after the deposit on January 1, 2030?
Mark deposited P1,200 in an account that pays 3 2% compounded monthly. He continues to deposit the same amount every end of the month. If the first deposit was made on June 1, 2017, how much is in the account just after the deposit is made on December 1, 2027?
Kavish loans $15,000 to his business partner on June 1st, 2020. The terms of the loan state that interest of 5% compounded annually will be paid when the loan matures on May 31st, 2022. What is the amount of interest income that Kavish must report in each year from 2020 2022? Show your calculations.