A friend of yours is interested in purchasing a motor vehicle with at a cost of $3.5 million. The bank has indicated that they are willing to finance 80% of the purchase price at a rate of 12% p.a. over 4 ½ years with equal monthly repayments. Your friend has asked you to Compute the required monthly payments. (round to the nearest dollar) Prepare the Loan amortization schedule for the first 4 months (round to the nearest dollar). Determine how much would be required to close the loan after 2 ½ years.

A friend of yours is interested in purchasing a motor vehicle with at a cost of $3.5 million. The bank has indicated that they are willing to finance 80% of the purchase price at a rate of 12% p.a. over 4 ½ years with equal monthly repayments. Your friend has asked you to Compute the required monthly payments. (round to the nearest dollar) Prepare the Loan amortization schedule for the first 4 months (round to the nearest dollar). Determine how much would be required to close the loan after 2 ½ years.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A local finance company quotes a 17 percent interest rate on one-year loans. So, if you borrow $30,000, the interest for the year will be $5,100. Because you must repay a total of $35,100 in one year, the finance company requires you to pay $35,100/12, or $2,925.00, per month over the next 12 months. a. What rate would legally have to be quoted? b. What is the effective annual rate?
Lorena's Cart took out a loan from the bank today for $245,800.00. The loan requires Lorena's Cart to make a special payment of $82,400.00 to the bank in 3 years and also make regular, fixed payments of X to the bank each year forever. The interest rate on the loan is 9.60 percent per year and the first regular, fixed annual payment of X will be made to the bank in 1 year. What is X, the amount of the regular, fixed annual payment? O $15,686.40 (plus or minus 3 dollars) O $62,588.64 (plus or minus 3 dollars) O $17,588.29 (plus or minus 3 dollars) O $23,596.80 (plus or minus 3 dollars) O none of the answers are within 3 dollars of the correct answer
You are going to purchase a new pick-up truck and decided to take a conventional vehicle loan in the amount of $60,175. You plan to finance the entire amount from a local bank. You plan to obtain a loan for 6 years and you were told the interest rate is 4.5% per year. Determine the monthly payments that you would make for the loan.
Suppose you secure a home improvement loan in the amount of $5,000 from a local bank. The loan officer gives you the following loan terms:• Contract amount = $5,000• Contract period = 24 months• Annual percentage rate = 12%• Monthly installment = $235 .37Shown is the cash flow diagram for this loan. Construct the loan payment schedule by showing the remaining balance, interest payment, and principal payment at the end of each period over the life of the loan.
Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1
You plan to purchase a $160,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.75 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 20th payment c. Calculate the amount of interest and, separately, principal paid in the 150th payment d. Calculate the amount of interest paid over the life of this mortgage. (For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) a. Monthly payment b. Amount of interest Amount of principal C. Amount of interest Amount of principal d. Amount of interest paid Amount
Suppose a graduate student receives a non-subsidized student loan of $11,000 for each of the 4 years the student pursues a PhD. If the annual interest rate is 5% and the student has a 10-year repayment program, what are the student's monthly payments on the loans after graduation? (Round your answer to the nearest cent.)
prepare an amortization schedule showing the first four payments for each loan. Large semitrailer trucks cost $110,000 each. Ace Trucking buys such a truck and agrees to pay for it by a loan that will be amortized with 9 semiannual payments at 8% compounded semiannually.
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $987 per month, and the total finance charge is $9,432. 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.) $ 8938.537
A computer chip designer purchased a car for $59,476.47, which includes sales tax and registration. The designer obtains a 5-year loan for the total amount at an annual interest rate of 6.3% compounded monthly. The designer will make monthly payments. The payments calculation for this type of loan uses the formula for the present value of which type of annuity? Given the formula for the payment amount of annuity where PMT is the payment amount in dollars, PV is the present value in dollars, n is the number of payments, and i is the interest rate per period. PMT= ? Determin the following values. PV= $ n= i= What is the designer’s monthly payment? (Round your answer to the nearest cent.)
You bought a house for $1,000,000. You paid 20% as the down payment and financed the rest. The mortgage loan has 30 years maturity and 4% APR which is compounded monthly. Use Excel Spread sheet to amortize the loan and find out the monthly principle and interest payments through out the life of this loan. I need this on an excel spreadsheet