Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of $35,000 which is to be paid off in full after 3 years. Interest is charged at a rate of 4.43% per year and the payment to the loan is to be made at the end of each month. Which function argument is correct? (Reminder: =PMT(rate, nper, pv, [FV], [type]) =PMT( 4.43%, 36, -35000) =PMT( 4.43%/12, 36, -35000) =PMT( 4.43%/12, 3, -35000) =PMT( 4.43%, 3, -35000)

Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of $35,000 which is to be paid off in full after 3 years. Interest is charged at a rate of 4.43% per year and the payment to the loan is to be made at the end of each month. Which function argument is correct? (Reminder: =PMT(rate, nper, pv, [FV], [type]) =PMT( 4.43%, 36, -35000) =PMT( 4.43%/12, 36, -35000) =PMT( 4.43%/12, 3, -35000) =PMT( 4.43%, 3, -35000)

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Use the PMT function in Excel to compute the monthly payment on a $351000 business loan at an annual interest rate of 4.46% over 30 years, where the interest is compounded monthly. Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type). Fv and Type are not necessary. Ignore them. Enter the amount of your monthly payment below. Do not include the dollar sign ($).
PLEASE Use the correct function on EXCEL
Use one of excel's TVM functions among =PV, =FV, =PMT, =RATE, =NPER, =CUMIPMT, =CUMPRINC answer this questions. (Please input the functions in excel and screeshot it )
In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12.
Using the information provided please show all work and formulas in excel ! Suppose that you have two loan choices with monthly payments (a) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for the entire term and there are no origination costs for the two loans? (b) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for only 6 years (72 months) and there are no origination costs for the two loans?
Assume you take out a car loan of $8,600 that calls for 48 monthly payments of $300 each. a. What is the APR of the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Use a financial calculator or Excel.) b. What is the effective annual interest rate on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
Task: Assume that at time 0 a sum L is lent for a series of n yearly payments. The rth payment, of amount x, is due at the end of the rth year. Let the effective annual interest rate for the rth year be i,. Give an identity which expresses L in terms of the x, and i,. Answer: The identity is [ Select ] [ Select ] L = x_1 (1+i_1)^(-1) + x_2 (1+i_1)^(-1) (1+i_2)^(-2) + .. + x_n (1+i_1)^(-1) (1+i_2)^(-2) ... (1+i_n)^(-n) L = x_1 (1+i_1) + x_2 (1+i_1) (1+i_2) + ... + x_n (1+i_1) (1+i_2) ... (1+i_n) L = x_1 (1+i_1)^(-1) + x_2 (1+i_1)^(-1) (1+i_2)^(-1) + .. + x_n (1+i_1)^(-1) (1+i_2)^(-1) ... (1+i_n)^(-1) Question 3 L = x_1 (1+i_1) + x_2 (1+i_1) (1+i_2)^2 + ... + x_n (1+i_1) (1+i_2)^2 ... (1+i_n)^n
Use technology to complete parts (a) through (c) below. ..... a. Find the monthly payment for a loan of $5000 with an APR of 12% and a loan term of 20 years. The monthly payment is $ (Round to the nearest cent as needed.)
With the given information please confirm if my calculations for how many years it will take to pay off this loan are correct. I need to use excel formulas. Amoutn of loan: 50,000 annual payment 10,000 interest rate: 8% I used the NPER function on excell and my answer was 6.64 years, is this correct?
An annuity pays $200 at the end of each period for 10 periods. Set up the CFs in an Excel spreadsheet. The current value of this stream of CFs is $1,544. What is the implied discount rate? Solve the problem using the following approaches: a. Use trial and error or Goal Seek in Excel (tab Data/What-if-Analysis). b. Use the excel built-in function RATE.
What is the monthly payment for a 5 year new car loan, when the nominal annual interest is 6%. After the down payment and other up-front charges, the amount borrowed is $21,000. Show your calculations and results using two methods: Use Engineering Economy factors and the compound interest tables found in Appendix C. Using spreadsheet. Set up table with known values and use Excel payment function (PMT
The weekly payment on a 4-year loan at 6.8% compounded weekly is $321.09. Calculate the amount of the loan. Identify the appropriate formula needed to calculate the amount of the loan. Select the correct choice below and fill in the answer boxes to complete your choice. (Type integers or decimals. Round to two decimal places as needed.) A. F= OB. P= O C. P= (1+i)^ - 1 F (1 + i)^ - • R, with F = $, n=[ and i=% with P = $ n= 1-(1+i)n i •R, with n= and i= % i= %, and R=$

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS