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

If you borrow $9000 at an annual percentage rate (APR) of r (as a decimal) from a bank, and if you wish to pay off the loan in 3 years, then your monthly payment M (in dollars) can be calculated using: M = 9000 (er/12-1) / 1 - e-3r 1) Describe what M (0.035) would represent in terms of the loan, APR, and time. 2) If you are only able to afford a max monthly payment of $300, describe how you could use the above formula to figure out what the highest interest rate the bank could offer you and you would still be able to afford the monthly payments. In addition, determine the maximum interest rate that you could afford.
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 ($).
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.)
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.)
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.
Percentages need to be entered in decimal format, for instance 3% would be entered as .03 in cell B12.) Set up an amortization schedule for a $60,000 loan to be repaid in equal installments at the end of each of the next 20 years at an interest rate of 20%. What is the annual payment? After you input the data for each scenario, click on the Graph tab (second tab on the worksheet) and look at the Principal and Interest portions of the payments throughout the years. What do you notice about the amount of Principal and Interest over the years (which amount is higher in the early years, and which amount is higher in the later years) of the loan? What do you notice about the difference in Principal and Interest in the 10% scenarios compared to 20% scenarios?
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=$
.Use the TVM solver on the calculator, fill in the information that you typed in the calculator.. What monthly payment is required to amortize a loan of $40,000 over 10 years if interest at the rate of 6% per year is charged on the unpaid balance and interest calculations are made at the end of each month? 2. Work Here (Keyboard only):
Your company is planning to borrow $1 million on a 5-year, 11%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places. %
Construct an amortization schedule (monthly) with the followings: House Price: 700,000 Down Payment: 20% of House Price Loan Period: 30 years Interest rate: 5.78% To get full credit, you must use Excel functions with relative cells to change the amortization schedule with variables such as price, interest, and load period. Please submit your Excel spreadsheet. (No other files are accepted)
Find the monthly payment and estimate the remaining balance. Assume interest is on the upaid balance. 3 year computer loan for $3285 at 6.6%, remaining balance after 2 years. The monthly payment is $ (Round to the nearest cent as needed.) The remaining balance is $ (Round to the nearest dollar as needed.)
What is the PV of an annuity due with 5 payments of $2,500 at an interest rate of 5.5%? Hint: when you see the word “due”, it means that the first payment happens right away (rather than at the end of the period) so you must adjust the formula, in Excel make type=1: =PV(Rate, nper, pmt, fv, type=1)

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