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

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 13PROB

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
Determining Loan Repayments Jerry Rockness needs 40,000 to pay off a loan due on December 31, 2028. His plans included the making of 10 annual deposits beginning on December 31, 2019, in accumulating a fund to pay off the loan. Without making a precise calculation, Jerry made 3 annual deposits of 4,000 each on December 31, 2019, 2020, and 2021, which have been earning interest at 10% compounded annually. Required: What is the equal amount of each of the next 7 deposits for the period December 31, 2022, to December 31, 2028, to reach the fund objective, assuming that the fund will continue to earn interest at 10% compounded annually?
Scrimiger Paints wants to upgrade its machinery and on September 20 takes out a loan from the bank in the amount of $500,000. The terms of the loan are 2.9% annual interest rate and payable in 8 months. Interest is due in equal payments each month. Compute the interest expense due each month. Show the journal entry to recognize the interest payment on October 20, and the entry for payment of the short-term note and final interest payment on May 20. Round to the nearest cent if required.
Blue Company, an architectural firm, has a bookkeeper who maintains a cash receipts and disbursements journal. At the end of the year (2019), the company hires you to convert the cash receipts and disbursements into accrual basis revenues and expenses. The total cash receipts are summarized as follows. The accounts receivable from customers at the end of the year are 120,000. You note that the accounts receivable at the beginning of the year were 190,000. The cash sales included 30,000 of prepayments for services to be provided over the period January 1, 2019, through December 31, 2021. a. Compute the companys accrual basis gross income for 2019. b. Would you recommend that Blue use the cash method or the accrual method? Why? c. The company does not maintain an allowance for uncollectible accounts. Would you recommend that such an allowance be established for tax purposes? Explain.
Mohammed LLC is a growing consulting firm. The following transactions take place during the current year. A. On June 10, Mohammed borrows $270,000 from a bank to cover the initial cost of expansion. Terms of the loan are payment due in four months from June 10, and annual interest rate of 5%. B. On July 9, Mohammed borrows an additional $100,000 with payment due in four months from July 9, and an annual interest rate of 12%. C. Mohammed pays their accounts in full on October 10 for the June 10 loan, and on November 9 for the July 9 loan. Record the journal entries to recognize the initial borrowings, and the two payments for Mohammed.
McMasters Inc. specializes in BBQ accessories. In order for the company to expand its business, they take out a long-term loan in the amount of $800,000. Assume that any loans are created on January 1. The terms of the loan include a periodic payment plan, where interest payments are accumulated each year but are only computed against the outstanding principal balance during that current period. The annual interest rate is 9%. Each year on December 31, the company pays down the principal balance by $50,000. This payment is considered part of the outstanding principal balance when computing the interest accumulation that also occurs on December 31 of that year. A. Determine the outstanding principal balance on December 31 of the first year that is computed for interest. B. Compute the interest accrued on December 31 of the first year. C. Make a journal entry to record interest accumulated during the first year, but not paid as of December 31 of that first year.
Preparing financial statements. Hugo Garcia is preparing his balance sheet and income and expense statement for the year ending December 31, 2020. He is having difficulty classifying six items and sks for your help. Which, if any, of the following transactions are assets, liabilities, income, or expense items? a. Hugo rents a house for 1,350 a month. b. On June 21, 2020 Hugo bought diamond earrings for his wife and charged them using his Visa card. The earrings cost 900, but he hasnt yet received the bill. c. Hugo borrowed 3,500 from his parents last fall, but so far, he has made no payments to them. d. Hugo makes monthly payments of 225 on an installment loan; about half of it is interest, and the balance is repayment of principal. He has 20 payments left, totaling 4,500. e. Hugo paid 3,800 in taxes during the year and is due a tax refund of 650, which he hasnt yet received. f. Hugo invested 2,300 in a mutual fund. g. Hugos Aunt Lydia gave him a birthday gift of 300.