Question: How to calculate this with excel ( need the formulas) 9. What is the present value factor in five years at 10 percent? 10. What

How to calculate this with excel ( need the formulas)

9. What is the present value factor in five years at 10 percent?

10. What is the present value of receiving $50,000 in five years at 10 percent?

11. What is the future value factor in seven years at 12 percent?

12. What is the future value of $30,000 in seven years at 12 percent?

13. What is the mortgage constant of a 30-year fixed-rate mortgage with monthly payments at 5 percent?

14. What is the monthly mortgage payment of a 30-year fixed-rate mortgage of $100,000 at 5 percent?

15. What is the value of a 20-year mortgage with monthly payments of $824.95 at 5 percent?

16. What is the value of a 20-year mortgage with monthly payments of $824.95 at 3 percent?

17. What is the value of a 20-year mortgage with monthly payments of $824.95 at 7 percent?

18. Suppose you borrow $325,000 at six percent for 30 years with monthly payments. What is the payoff (balloon payment) in three years?

19. Suppose you borrow $325,000 at six percent for 30 years with monthly payments and a prepayment penalty of 2 percent. What is the payoff (balloon payment) in three years?

20. What is the monthly payment in year six of an adjustable-rate mortgage where $350,000 is borrowed at an interest rate of 4.5 percent for the first five years that resets to 6 percent in year six?

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 Finance Questions!

High End short term rentals: Task Steps: Identify Key Financial Data: Extract the following key financial data from the provided dataset: Total Yearly costs including insurances, utility bills,...

9 (1 point) The present value factor is the inverse of the future value factor. Question 9 options: True False Question 10 (1 point) Suppose you are offered an investment that pays $15,000 in five...

Hello tutor please open the attached file and help me solve the question in about 2 hours and 20 minutes time or as soon as possible. It is due in about two hours. Please ask for any clarification...

please use excel and show formulas 11. What is the present value of $3,400 per year, at a discount rate of 9 percent, if the first payment is received 5 years from now and the last payment is...

Question: Virus Stopper Inc., a supplier of computer safeguard systems, uses a cost of capital of 10 percent to evaluate average-risk projects, and it adds or subtracts 3 percentage points to...

Help me please with clear and detailed explanation of the answer 9. You expect to receive P1.000 at the end of each of the next 3 years. You will deposit these payments into an account which pays...

You are serving on a jury. A plaintiff is suing the city for injuries sustained after a freak street-sweeper accident. In the trial, doctors testified that it will be frve years befor The present...

Exercise 21-7 On January 1, 2017, Sarasota Company leased equipment to Ivanhoe Corporation. The following information pertains to this lease. 1. The term of the noncancelable lease is 6 years, with...

For the following problems show your steps if using a financial calculator or upload the excel spreadsheet if using excel. You just purchased a $1,000 semiannual corporate par value bond with a 10...

Can you think of any new kinds of security that might appeal to investors? Why do you think they have not been issued?

Summarize the steps for solving a linear programming model graphically.

Security Expected annual rate of return Meta 1 1 % Microsoft 1 3 % ASML 1 7 % Netflix 2 2 % The investor plans to sell ASML and use the proceeds to buy a new stock that has the same expected return...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Describe three situations that would require a businessperson to use the indirect plan for a negative message. (Objective 4)

Select the most effective plan for developing negative messages (direct or indirect) for the following situations and justify your choice: (Objective 2) a. A routine meeting is canceled. b. A...

Technology. You manage Sunset Lane, a small card and gift shop. On September 3, you ordered four cases of shower gel and four cases of body lotion, one of each in the following fragrances: White...