Your cousin has asked you to help him analyze the cash flows for a $40,000, 3-year loan he is considering taking out. He has two choices for structuring hispayments: levelprincipal or level payments. He has asked you to prepare an amortizationschedule for eachloan structure. Both loans have an APR of 7% and monthly payments. Which loanhas thesmaller payment in month 15?

ConclusionLevel Payments: $1,235.08 (smaller)Level Principal Payments: $1,253.70The loan with level…

Answered: Your cousin has asked you to help him…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

We will use Excel PMT function to calculate the payment Rand then create an amortization schedule for the problem below: The Turners have purchased a house for $250,000. They made an initial down payment of $50,000 and secured a mortgage with interest charged at the rate of 6%/year on the unpaid balance . Interest computations are made at the end of each month . Assume that the loan is amortized over 15 years . Determine the size of each installment such that the loan is amortized at the end of the term Type the raw data of P, r, m, t into cells Calculate i by its definition Calculate n by its definition Calculate R by Excel function PMT. Note : please reference in PMT What will be their total interest payment ?
You are in negotiations to make a 7 - year loan of $31, 000 to DeVille Corporation. To repay you, DeVille will pay $2, 500 at the end of Year 1, $5, 000 at the end of Year 2, and $7,500 at the end of Year 3, plus a fixed but currently unspecified cash flow, X, at the end of each year from Year 4 through Year 7. You are confident the payments will be made, since DeVille is essentially riskless. You regard 8% as an appropriate rate of return on a low risk but illiquid 7 year loan. What cash flow must the investment provide at the end of each of the final 4 years that is, what is X? Select the correct answer. a. $7,037.75 b. $7, 049.05 с. $7, 003.85 d. $ 7,015.15 e. $7,026.45
You are in negotiations to make a 7-year loan of $22,000 to DeVille Corporation. To repay you, DeVille will pay $2,500 at the end of Year 1, $5,000 at the end of Year 2, and $7,500 at the end of Year 3, plus a fixed but currently unspecified cash flow, X, at the end of each year from Year 4 through Year 7. You are confident the payments will be made, since DeVille is essentially riskless. You regard 8% as an appropriate rate of return on a low risk but illiquid 7-year loan. What cash flow must the investment provide at the end of each of the final 4 years, that is, what is X? A.3558.55 B.3,603.35 C.3,580.95 D.3,592.15 E. 3,569.75
Example: In this exercise prepare an amortization schedule showing the payments for each loan. Joan Varozza plans to borrow $20,000 to stock her small boutique. She will repay the loan with semiannual payments for 5 years at 7% interest. SET UP AN AMORTIZATION TABLE
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master It
You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of $3,000, with the first payment to be received 1 year from now. What rate of return does your loan receive? I need to be able to use excel and manually calculate as well.
Jake has approached you for a loan and based on your assessment, his cash-flow will accommodate a repayment of $6,000 per month. He has agreed to a 5-year repayment term at an interest rate of 16% add-on. What is the maximum loan that Jake can be given? Select one: Oa. $30.000 b. $360,000 c. $160.000 d. $200.000
You have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) LoanPayment PaymentPeriod Term ofLoan (years) NominalRate (%) Present Value(Amount of Loan) $ every month 1 3 4 6 $40,000
You borrowed $18,000 from a friend and promised to pay the loan in 12 equal annual installments beginning one year from the date of the loan. Your friend would like to be reimbursed for the time value of money at a 9% annual rate. What is the annual payment you must make to pay back your friend? Note: Do not round intermediate calculations. Round your final answers to nearest whole dollar amount. Show less Table, Excel, or calculator function not attempted Present Value: not attempted n = not attempted i = not attempted Annual Installment:
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)
Please show working. please answer a and b (a) You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 5% with interest paid monthly. What will be the monthly loan payment? What will be the loan's EAR? Do not round intermediate calculations. Round your answer for the monthly loan payment to the nearest cent and for EAR to two decimal places. Monthly loan payment: $ _________ EAR: __________ % (b) What's the future value of a 9%, 5-year ordinary annuity that pays $300 each year? If this was an annuity due, what would its future value be? Do not round intermediate calculations. Round your answers to the nearest cent. Future Value of an Ordinary Annuity: $ Future Value of an Annuity Due: $
Akuse Tours company secures a loan of GHS200,000 over 2 years at 10.5% compounded quarterly year to purchase more tour buses for the upcoming Christmas festivities. Requirements: a. Compute the quarterly installment the entity will be required to pay. b. Prepare a spreadsheet model indicating the installment and the loan amortization schedule.

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Intermediate Accounting: Reporting And Analysis

Accounting

ISBN:

9781337788281

Author:

James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS