I did the “required 1” but stuck on how to do “required 2” Exercise 5-10 (Algo) Future and present value [LO5-3, 5-7, 5-8]Answer each of the following independent questions.Alex Meir recently won a lottery and has the option of receiving one of the following three prizes: (1) $60,000 cash immediately, (2)$18,000 cash immediately and a six-period annuity of $7,500 beginning one year from today, or (3) a six-period annuity of $11,800beginning one year from today. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) fromthe tables provided.)1. Assuming an interest rate of 5%, determine the present value for the above options. Which option should Alex choose?2. The Weimer Corporation wants to accumulate a sum of money to repay certain debts due on December 31, 2030. Weimer will makeannual deposits of $105,000 into a special bank account at the end of each of 10 years beginning December 31, 2021. Assuming thatthe bank account pays 6% interest compounded annually, what will be the fund balance after the last payment is made on December31, 2030?Complete this question by entering your answers in the tabs below.Required 1Required 2The Weimer Corporation wants to accumulate a sum of money to repay certain debts due on December 31, 2030. Weimer willmake annual deposits of $105,000 into a special bank account at the end of each of 10 years beginning December 31, 2021.Assuming that the bank account pays 6% interest compounded annually, what will be the fund balance after the last paymentis made on December 31, 2030? (Round your final answers to nearest whole dollar amount.)Show lessTable or calculator function:Payment:Future value:

Future Value of Annuity: It represents the future worth of the present annuity cash flow stream and…

ner will IKto a special bank account at the end of each of 10 years beginning December 31, 2021. Assuming that the bank account pays 6% interest compounded annually, what will be the fund balance after the last payment is made on December 31, 2030? (Round your final answers to nearest whole dollar amount.)

ner will IKto a special bank account at the end of each of 10 years beginning December 31, 2021. Assuming that the bank account pays 6% interest compounded annually, what will be the fund balance after the last payment is made on December 31, 2030? (Round your final answers to nearest whole dollar amount.)

Fundamentals of Financial Management (MindTap Course List)

15th Edition

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter12: Cash Flow Estimation And Risk Analysis

Section: Chapter Questions

Problem 5P: EQUIVALENT ANNUAL ANNUITY Faleye Consulting is deciding which of two computer systems to purchase....

See similar textbooks

Similar questions

5.-DO IT IN EXCEL, AND SHOW THE FORMULASThe company purchases a machine, its cost of $726,000 will be financed with a loan at 13.8% interest for three years that requires equal semi-annual payments (annuities) that include principal and interest. What is the amount of the payment? A) $185,674.92 B) None of these amounts C) $311,662.137 D) $151,841.86 (Choose one option) D) $151,841.86
H3. A loan of $18430 is to be repaid at 4% effective by payments of $1500 at the end of each year for as long as possible and an additional smaller payment X made one year after the last full payment. Calculate X. A 367.68 B 369.17 C 358.25 D 353.54 E 376.99 Please show proper step by step calculation
7. Please show all work and use answer choices included. _____________________________________________________________________________________________________ A promissory note calling for payments of $1,100 at the end of each year for the next 13 years is offered for sale for $11,000. What is the prospective rate of return nearly exactly at? A. 2% B. 4% C. 6% D. 8%
39 Identify the correct formula to calculate the payment for a loan, where the rate is 6%, the loan amount is $2,000, and payments will be made monthly for six years. =PMT(6,6*12,2000) =PMT(.06/12,6*12,-2000) once=1/1b1435-b60f-40fb-ad57-d89084c2075a&launchCode=qe8mtdEeV5pWjPP2nq... =PMT(.06,6*12,-2000) =PMT(.06,6*12,2000)
Q5) . As winner of horse race competition, you can choose one of the following prizes: 1. $100,000 now. 2. $180,000 at the end of five years. 3. $19,000 for each of 10 years. If the interest rate is 12%, which is the most valuable prize based on the present value?
Need an accurate answer on this！ Sprint Inc. expects the following: UCFBT=$ 10 million in perpetuity from the end of year 1. Debt= $ 20 million. Rb =5% Tax rate is 50% R0 =10% Debt is fully amortized over 3 years in three equal payments. Find the value of Sprints’ equity today. Question content area bottom Part 1 Sprints Equity today is $ million. (Round to two decimals) Use 99 if the answer is indeterminate
H5. 1.Kenneth's retirement fund has an accumulated amount of $50,000. If it has been earning interest at 5.14% compounded monthly for the past 23 years, calculate the size of the equal payments that he deposited at the beginning of every 3 months. $0.00 2.Morgan leased equipment worth $60,000 for 7 years. If the cost of borrowing is 4.66% compounded semi-annually, calculate the size of the lease payment that is required to be made at the beginning of each half-year.
SHOW COMPLETE AND ORGANIZED SOLUTION. PLEASE ANSWER THE 2 QUESTIONS. THANK YOU2)If you are to invest your money, which is a better option: 12% compounded monthly, 12.20% compounded quarterly, 12.35% compounded semi-annually or 12.5% compounded annually?3) Determine the ordinary and exact simple interest on P60,000.00 for the period from January 16 to November 26, 2008 if the rate of interest is 14%
EQUIVALENT ANNUAL ANNUITY Faleye Consulting is deciding which of two computer systems to purchase. It can purchase state-of-the-art equipment (System A) for 21,000, which will generate cash flows of 6,000 at the end of each of the next 6 years. Alternatively, the company can spend 11,000 for equipment that can be used for 3 years and will generate cash flows of 6,000 at the end of each year (System B). If the company's WACC Is 10% and both "projects" can be repeated indefinitely, which system should be chosen, and what is its EAA?