Does anyone know the answer to this one? I'm stuck. X ExceltemplateSavedFileFormulasDataReviewTell me what you want to doOCommeHomeInsertViewHelpX Cut- 10 - A A"國国 EAsm-ArialCurrencya CopyPasteFormat Painter$ - % > *Conditional Format CellInsert Delete FormatFormatting - as Table - Styles -ClearSort & Find &Filter - SelectUndoCipboardFontAlignmentNumberTabiesCelsEditingB14DEGPresent value of an annuityDATA4 Sum of prize5 Annual payment6 Number of years7 Interest rate8 Date of win9 Date of payments$46,000,000$5,750,00085.0%January 1December 31 of each year10Using formulas and cell references, perform the required analysis, and input youranswer into the Amount column. Transfer the numeric result for the green entry cell11 (814) into the appropriate field in CNOWV2 for grading.1213AmountFormula14 PV of annual payments1516 Chapter 11 Homework (Application)elookShow Me Howg omice 365Calculator3. BE 11.03 ALGOPresent value of an annuity4. BE.11.05 ALGOOn January 1, you win $46,000,000 in the state lottery. The $46,000,000 prize will be paid in equal installments of $5,750,000 over eight years. Thepayments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been5. BE.11.06.BLANKSHEETcollected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.6. EX 11.017. EX 11.02 ALGOOpen spreadsheet8. EX 11.03 ALGODetermine the present value of your winnings. Round your answer to the nearest dollar.9. EX 11.05 ALGO10. EX 11.0711. EX.11.1512. PR 11.01A.BLANKSHEET13. PR 11.02A BLANKSHEET14. EX 11.10. EXCEL ALGO15. EX 11.12.EXCELALGO16. EX 11.16.EXCELALGO

Here, Sum of Prize is $46,000,000 Annual Payments is $5,750,000 Number of years is 8 Interest Rate…

Present value of an annuity On January 1. you win $46,000,000 in the state lottery. The 545,000,000 prize will be paid in equal installments of $5,750,000 over eight years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Miorosoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Present value of an annuity On January 1. you win $46,000,000 in the state lottery. The 545,000,000 prize will be paid in equal installments of $5,750,000 over eight years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Miorosoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

First Time Value of Money Homework i Help Save & Exit Submit 13 Mary is going to receive a 31-year annuity of $9,600 per year. Nancy is going to receive a perpetuity of $9,600 per year. If the appropriate interest rate is 9 percent, how much more is Nancy's cash flow worth? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. 10 Present value Book Prent Reterences: Present value
CH9HW i Help Save & Exit Submit a. A friend of yours, Grace, wants to purchase a house in five years. To save for the house, Grace decides to deposit $140,000 in a savings account on January 1 of this year. The savings account will earn 8 percent annually. Any interest earned will be added to the fund at year-end (rather than withdrawn). b. At the end of each year, a different friend, Claire, plans to deposit $10,400 in a savings account. The account will earn 11 percent annual interest, which will be added to the fund balance at year-end. Claire will make her first deposit at the end of this year. (FV of $1, PV of $1, FVA of
Week # 5 Homework Assignment (Chapter 7 - 8) Q1. You plan to purchase a $100,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8.25%. You will make a down payment of 20 percent of the purchase price. Calculate your monthly payments on this mortgage. Calculate the amount of interest and, separately, principal paid in the 25thpayment. Calculate the amount of interest paid over the life of this mortgage.
Calculator sequence (1+(i÷365))y× n x P=A A. On April 13th Thomas Ash deposited $2600 in a passbook savings account at 3.5% interest compounded daily what is the compound amount in $ of his account on August 5th? $ B. Using daily compounding calculate the compound amount in $ of a $6000 investment for each of the 3 Cd's. the 1st national bank is offering a 5 year CD 4% interest.....$ the 2nd national bank is offering a 5 year CD at 3% interest....$ the 3rd national bank has a 5 year CD at 5.5% interest .....$
eBook Problem 7-02 A self-employed person deposits $4,000 annually in a retirement account (called a Keogh or H.R. 10 plan) that earns 9 percent. Use Appendix A and Appendix C to answer the questions. Round your answers to the nearest dollar. How much will be in the account when the individual retires at the age of 65 if the savings program starts when the person is age 50?$ How much additional money will be in the account if the saver defers retirement until age 70 and continues the contributions?$ How much additional money will be in the account if the saver discontinues the contributions at age 65 but does not retire until age 70?$
eBook Chapter 14Financial Planning Exercise 8Deciding between traditional and Roth IRAs Elijah James is in his early 30s and is thinking about opening an IRA. He can't decide whether to open a traditional/deductible IRA or a Roth IRA, so he turns to you for help. To support your explanation, you decide to run some comparative numbers on the two types of accounts; for starters, use a 25-year period to show Elijah what contributions of $5,000 per year will amount to (after 25 years) if he can earn, say, 9 percent on his money. Round your answers to the nearest dollar. Traditional IRA $ Roth IRA $ Will the type of account he opens have any impact on this amount?-Select-YesNoItem 3 Explain. Assuming that Elijah is in the 25 percent tax bracket (and will remain there for the next 25 years), determine the annual and total (over 25 years) tax savings he'll enjoy from the $5,000-a-year contributions to his IRA. Contrast the (annual and total) tax savings he'd generate…
QUESTION 14 You purchase a home priced at 1,750,000 Php. You paid 10% as the down payment and the remaining balance under a bank amortization plan to be paid in 8 years. At an effective quarterly interest rate of 1.5%, How much interest will you pay in the 2nd year Solve on white paper or typed. Not in excel
Problem 7-04 You annually invest $1,000 in an individual retirement account (IRA) starting at the age of 30 and make the contributions for 10 years. Your twin sister does the same starting at age 45 and makes the contributions for 20 years. Both of you earn 6 percent annually on your investment. What amounts will you and your sister have at age 65? Use Appendix A andAppendix C to answer the question. Round your answers to the nearest dollar.Amount on your account: $ Amount on your sister's account: $ Who has the larger amount at age 65?-Select-You haveYour sister hasItem 3 the larger amount.
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.)
Please correct and stepwise both parts or skip pls. Q1 part 1. Brenda plans to reduce her spending by $80 a month. Calculate the future value of this increase in savings over the next 10 years. (Assume an annual deposit to her savings account, and an annual interest rate of 4 percent.) Note: Use appropriate factor(s) from the tables provided. Round time value factor to 3 decimal places and final answer to 2 decimal places. part 2. Kara Delaney received a $3,000 gift for graduation from a relative. If she deposits the entire amount in an account paying 3 percent, what will be the value of this gift in 15 years?.
eBook Problem 7-15 You are offered $1,100 after six years (Offer 1) or $150 a year for six years (Offer 2). If you can earn 6 percent on your funds, calculate the future values of both payments. Use Appendix C to answer the question. Round your answers to the nearest dollar.FV(Offer 1): $ FV(Offer 2): $ Which offer will you accept? -Select-Offer 1Offer 2Item 3 If you can earn 16 percent on your funds, calculate the future values of both payments. Use Appendix C to answer the question. Round your answers to the nearest dollar.FV(Offer 1): $ FV(Offer 2): $ Which offer will you accept, if you can earn 16 percent on your funds? -Select-Offer 1Offer 2Item 6 Why are your answers different? The choices are different as the higher interest rate -Select-favors early paymentsfavors late paymentsItem 7 .
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.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

SEE MORE TEXTBOOKS