Question: Please help me understand formulas to be used in excel with answers rounded to 2 decimal places. Thank you!! b. What is the present value

Please help me understand formulas to be used in excel with answers rounded to 2 decimal places. Thank you!!

b. What is the present value of a security that will pay $30,000 in 15 years if securities of equal risk pay 5.25% annually?

c. You have $89,000 in a brokerage account, and you plan to deposit an additional $22,000 at the end of each future year until your account reaches $750,000. You expect to earn 13% annually on the account. How long will it take to reach your goal?

d. You just received an inheritance worth $150,000. You want to retire in 25 years and you plan to contribute an additional $15,000 at the end of each year. If you need $1,500,000 in order to retire, what interest rate must you earn in order to reach your goal?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

please help Solve for the unknown interest rate in each of the following (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.):...

4. Find the APR, or stated rate, in each of the following cases: (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 3216J Stated Rate...

please help First City Bank pays 9 percent simple interest on its savings account balances, whereas Second City Bank pays 9 percent interest compounded annually. If you made a deposit of $7,500 in...

Solve for the unknown interest rate in each of the following ( Enter rounded answers as directed, but do not use rounded numbers in intermediate calculations. Enter your answer as a percent rou nded...

Hello, please assist. Thank you! Check my work 4 S05-03 Calculating Present Values [LO2] 10 For each of the following, compute the present value (Do not round intermediate calculations and round your...

1.Calculate the number of shares issued through this IPO. Louisiana Timber Company currently has 2 million shares of stock outstanding and will report earnings of $6.79 million in the current year....

Dobbs Corporation is considering purchasing a new delivery truck. The truck has many advantages over the company's current truck (not the least of which is that it runs). The new truck would cost...

PLEASE HELP ME! 1 2 3 4 JUST 4 QUESTIONS PLEASE! GUARUNTEED THUMBS UP! THANKS!!! Solve for the unknown number of years in each of the following (Do not round Intermediate calculations and round your...

For each of the following, compute the future value: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Present Value Years Interest Rate Future Value $...

PLease show work. THank you Solve for the unknown interest rate in each of the following: (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places,...

For this assignment , you are asked to build a full Android application to perform an E-exams. As per the following requirements : 1. Your app should begin with a login form, where the user enters...

Mullet Technologies is considering whether or not to refund a $75 million, 12 percent coupon 30-year bond issue that was sold 5 years ago. It is amortizing $5 million of flotation costs on the 12...

A Client invests $ 2 5 0 , 0 0 0 and requires a portfolio manager to create a portfolio that closely tracks the Index. A strategy that the portfolio manager can employ to achieve this goal is: Group...

If the following join statement is used to join two tables in a query, which of the following tables would all of the tuples in the relation appear in results? left join university.students on...