Question: please answer using excel and explain 6) You will borrow $1,000 each year for 20 years at a rate of 4.5% and pay back the

please answer using excel and explain

6) You will borrow $1,000 each year for 20 years at a rate of 4.5% and pay back the loan immediate after receiving the last payment. What is the total amount that you will repay? Use Excel's =FV(RATE,NPER,PMT, [PV], [TYPE]) function. RATE is 4.5%, NPER is 20 , PMT is $1,000, and TYPE is 0 since payments are made at the end of the period. If the [type] argument is omitted, it takes on the default value of 0

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!

please answer using excel and explain 18) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the MIRR if the...

please answer using excel and explain 12) You are planning to send your daughter to college in 20 years. You estimate that you will need $100,000 at that time to pay for tuition, room, and board. How...

Please answer using Excel in the exact format given below Mixed Use Project FIRE 305, Principles of Real Estate, Fall 2018 Tenant Assumptions Assumptions Tenant Remaining Lease Term Gross Leasable...

Please answer using excel formulas with clear text (preferably typed). Thanks Use what you have learned about the time value of money to analyze each of the following decisions: Decision #1: Which...

Company A deposit $10,000 now in the bank. Company A will keep deposits $1500 at the end of each payment period. The interest rate and the payment period information are given in the following table....

Edit: The information from the previous question is not needed for the question Please answer using excel formula, leave answers to 2 dp, but use the exact amount from the previous question to answer...

Refer to the Retirement Planning case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercise in Chapter 2. (If this has not...

PLEASE ANSWER USING EXCEL FORMULAS. B D E T1 G H 1 2 3 Given the following information for Watson Power Co., find the WACC. Assume the company's tax rate is 21 percent. Debt: 10,000 6.4 percent...

Hello. I'm looking for some help completing my finance project. (10% total course grade) There are quite a few questions. (40 total) I can check the answers one time before submitting. Hoping for...

Describe the detailed mathematical expression for Doppler Broadening of Spectra?

Find the diameter of a cylinder with a volume of approximately 310.86cm^(3) and a height of 11cm.

If we look at a truth table and see only F in the column under a sentence, we know it is a Contradiction. Question 2 options: True False

The mission statement of an organization: Identifies the company Tells the reader why the company exists States the fundamental purpose of the company All of the above None of the above

(Appendices) PURCHASES, PURCHASE RETURNS, AND PAYMENT FOR PURCHASES. Jordan Footwear sells athletic shoes. During April Jordan made the following purchases on credit with terms 3/15, n/40: LO4 Assume...

(Appendices) SALES AND SALES RETURNS WITH DISCOUNTS. Fuente Office Supply sells all merchandise on credit with terms 2/10, n/30. Fuente engaged in the following transactions: a) May 1: Fuente sold 50...

(Appendices) Choose five food, beauty, or household products you find in your home. Visit a local store and compare three different sizes of the product and compute unit prices. Compile the...