Question: need help Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B5, the APR is in

need help

Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B5, the APR is in B3, and the number of years is in B4. O =PMT(B3/12,B4 12,-B5) O =-PMT(B5/12,B4 12,-B5) --PMT(B5 12,84/12,-B5) O =PMT(B3 12,14/12,-B5) Write a function to calculate the payment on a loan where the purchase price is in cell B10, the down payment is in cell B12, the APR is in B3, and the number of payments is in B4. O E-PMT(B3/12,B4,B10-B12) O =PMT(B3'12,B4,B10-B12) O =-PMT(B3' 12,B4 12,B10 12) O =-PMT(B3 12,B4/12,B12)

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 this has to do with excel spreadsheets equations. Write a formula to find the discounted price of an item. Assume cell B2 has the original full price. The percentage by which the price is...

Write a function to calculate the payment on a loan where the purchase price is in cell B10, the down payment is in cell B12, the APR is in B3, and the number of payments is in B4. O =PMT(B3...

EXCEL SPREADSHEETS. Need urgent help. Write a formula to find the discounted price of an item. Assume cell B2 has the original full price. The percentage by which the price is being reduced is in...

Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B1, the down payment is in cell B2, the APR is in B3, and the number of payments is in B4. Group of...

Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B5, the, the APR is in B13, and the number of years is in B14. =PMT(B13*12,B14/12,-B5)...

Exercise 1.10-3 Chapter Review - Financial Functions Price A C D E F annual Selling interest 1 Make rate % down months Payment 2 Toyota 19,500 6.9% 10% 48 (5419.44) 3 Honda 18,700 7.3% 0% 48...

steps 8-16 please Open the flle SC_EX19_4b_FirstLastName_1.xisx, avaliable for download from the SAM website. Save the file as SC_EX19_4b_FirstlastName_2. x _. If you do not see the x isx file...

Use Excel to create an amortization table for a loan liability (use the same format we used in class). The excel user's guide for accountants will be very helpful for this problem. Do not down load a...

Purpose: To demonstrate the ability to create a worksheet that utilizes financial functions and contains a data table. Problem: The time has come for you to purchase a car. After years of saving, you...

PROJECT STEPS Ricardo and Miranda Ramos are considering whether to buy their first home, and have spoken to three lenders about taking out a mortgage for the house purchase. They now pay $1,500 per...

On January 1, 2010, the Orr Company sells heavy equipment to Foible Company for $3 million, then immediately leases it back. The relevant information is as follows: The lease is noncancelable and has...

Following are a series of statements regarding topics discussed in this chapter. Required: Indicate whether each statement is true (T) or false (F). (a) The terms depreciable cost and acquisition...

Crow Corporation invests $10 million in fixed assets and its accounts payable increase by $5 million. The fixed asset increase is a _____ of funds and the payable increase is a _____ of funds

One of the disadvantages of operating a business - to - consumer ( B 2 C ) e - commerce business as opposed to a physical store is the lack of flexibility. True False

Discuss the role of the HRM function in strategy formulation. page 79

Discuss how human resource management affects a companys balanced scorecard. page 29

Every time we allow the post offi ce to deliver packages late and we just grumble to ourselves and say nothing to our postal carriers, we enable mail delivery services around the world to continue at...