Question: How do I show my work for these problems in Excel? Present Value (PV) Payment (PMT) Future Value Annual Rate Periods (N) Compounding (W/M/Qtr/ Mode

How do I show my work for these problems in Excel?

Present Value (PV) Payment (PMT) Future Value Annual Rate Periods (N) Compounding (W/M/Qtr/ Mode Annual) (End/Begin) 1 2 3 4 5 6 7 8 9 10 11 12 1. Calculate the monthlypa ment for a home loan of $800,000 financed at 8.0% over 30 years. 2. Calculate the monthly payment for a home loan in Detroit of $200,000 financed at 7% over 15 years. Note the buyer will only finance 80% of the purchase price and make a down payment of 20%. 3. Calculate the future value of $25,000 invested for 10 years assuming an annual interest rate of 6%, cpmpounded month 4. Calculate the future value of $2,000 invested for 9 years assuming an annual interest rate of 9%. 5. Calculate the future value of an ordinary annuity of $1 ,OOO paid monthly for 10 years, assuming an annual earnin rate of 10%. 6. Calculate the annual interest rate that a bank must pay on a Certificate of Deposit if a client deposited $5,000 and withdrew $50,000 in 25 years. Assuming the interest is compounded on a monthly basis.

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!

45 Doug Turner Food Processors wishes to introduce a new brand of dog biscuits composed of chicken and liver flavored biscuits that meet certain nutritional requirements. The liver flavored biscuits...

1. Calculate the monthly payment for a home loan of $800,000 financed at 8.0% over 30 years. na ab appula inter Present Value (PV) Payment (PMT) Future Value Annual Rate (FV) (I) Compounding Periods...

Time Value of Money: Problem Set #2 As a savings plan, Kevin is going to shove $500 per vear under his mattress for 20 years, like an idiot a. How much would he have at the end of 20 years?...

The bond consists of a 10-year, 10% annuity of $60/year plus a $600 lump sum at t=10. Note: To receive full credit, show numbers / formulas you used to get your answer(s). a.(3 points) Find present...

look at all pictures. i submitted this question 3 times and no ones solving it. i need it asap please. look at all parts Caleb wants to go to college in 2 years to study travel and tourism. He...

1. Alisha's house is 15 years old, and it needs a new roof. A local roofing company quoted $16000 for the job. She plans to have the job done two years from now. TVM Advanced Calculator a) Alisha's...

Let's say you're trying to pay back the average university student debt of $32,000 . Ideally, you want to pay the least amount of interest (extra $ to the bank). Using your intuition, guess which...

Present Value 640,000 Payments 2,802.91 Future Value Annual Rate% 3.3 Periods 360 Compounding Monthly PV PMT FV RATE PERIOD Mode End O Beginning This $2,803 30-year mortgage payment is significantly...

Help me how to calculate college contribution for the following clients Clients information Martin & Kathleen Martin's Age 58, plans to retire at age 68 Salary $150,000 with expected 4% raise per...

Discussion 1 Read the chapter summary on pages 176-178. Imagine you are responsible for explaining any 3 key terms from the chapter to your coworkers. Create a verbal depiction, PowerPoint...

Write a class House defined as follows: A constructor that takes three arguments: an integer p, an integer s, and a string c. The values of those three local variables must be assigned to three...

Return to the original SeaView example in Exhibits 5- 5 and 5- 7. Suppose direct labor is $ 34,000 rather than $ 21,250. Now what is the conversion cost per equivalent unit? C H

les post - Licensing Classroom Final Assessment Final Assessment When working with short sales, a deal breaker may stop the sale. Which is NOT considered a deal breaker? A . lender forecloses on the...

Ms. Tyson keeps a Mystery Box in her classroom. If a student meets expectations for behavior, she or he is allowed to draw a slip of paper without looking. The slips are all of equal size, are well...

The force of gravity on the Moon is one-sixth (i.e., 1/6.0) as strong as the force of gravity on Earth. An apple weighs 1.0 N on Earth. (a) What is the mass of the apple on the Moon, in lbm? (b) What...

The semicircular disk of mass m and radius r is released from rest at = 0 and rotates freely in the vertical plane about its fixed bearing at O. Derive expressions for the n- and t-components of the...

Distinguish among positive linear, negative linear, and curvilinear relationships.

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

describe the different cost- plus pricing methods for deriving selling prices; LO1

Advanced Discuss the extent to which cost data is useful in the determination of pricing policy. Explain the advantages and disadvantages of presenting cost data for possible utilization in pricing...

Advanced At one of its regular monthly meetings the board of Giant Steps Ltd was discussing its pricing and output policies. Giant Steps Ltd is a multi-product firm, operating in several distinct but...