Question
In: Finance
You plan to borrow $75,000 to purchase a small yacht, 2014 Maritimo X50, with financing from...
You plan to borrow $75,000 to purchase a small yacht, 2014 Maritimo X50, with financing from Capital One Bank. You can afford to make monthly payments of $1,475, but no more. Assuming monthly compounding, what is the highest rate you can afford on a 60-month APR loan? What is the APR on this loan? What is the EAR on this loan? Prepare an amortization schedule on the 60-month yacht loan and determine the total interest paid after 5 months
Solutions
Expert Solution
APR is calculate using RATE function in Excel :
nper = 60 (60 month loan)
pmt = -1475 (Monthly payment. This is entered with a negative sign as it is a cash outflow)
pv = 75000 (Loan amount)
The NPER calculated is the monthly rate. To get APR, we multiply by 12.
APR = 6.7143%
EAR = (1 + (APR/n))n - 1
where n = number of compounding periods per year
EAR = (1 + (6.71%/12))12 - 1
EAR = 6.9248%
Total interest paid after 5 months = $2,039
jeff jeffy answered 1 year agoRelated Solutions
You plan to borrow $75,000 to purchase a small yacht, 2014 Maritimo X50, with financing from...
You plan to borrow $75,000 to purchase a small yacht, 2014
Maritimo X50, with financing from Capital One Bank. You can afford
to make monthly payments of $1,475, but no more. Assuming monthly
compounding, what is the highest rate you can afford on a 60-month
APR loan? What is the APR on this loan? What is the EAR on this
loan? Prepare an amortization schedule on the 60-month yacht loan
and determine the total interest paid after 5 months. (Help...
You plan to borrow $75,000 to purchase a small yacht, 2014 Maritimo X50, with financing from...
You plan to borrow $75,000 to purchase a small yacht, 2014
Maritimo X50, with financing from Capital One Bank. You can afford
to make monthly payments of $1,475, but no more. Assuming monthly
compounding, what is the highest rate you can afford on a 60-month
APR loan? What is the APR on this loan? What is the EAR on this
loan? Prepare an amortization schedule on the 60-month yacht loan
and determine the total interest paid after 5 months.
Provide...
Problem 15-7 (similar to) (Cost of short-term financing) You plan to borrow $30 comma 000 from...
Problem 15-7 (similar to) (Cost of short-term financing) You
plan to borrow $30 comma 000 from the bank to pay for inventories
for a gift shop you have just opened. The bank offers to lend you
the money at 11 percent annual interest for the 6 months the funds
will be needed. a. Calculate the effective rate of interest on the
loan. b. In addition, the bank requires you to maintain a
compensating balance of 18 percent in the bank....
1. Assume you need to borrow $150,000 to purchase a home. You plan on living in...
1.
Assume you need to borrow $150,000 to purchase a home. You plan
on living in your new house for only 6 years, so you are trying to
determine whether you want an
adjustable or fixed rate mortgage from your bank. Both loans
would be amortized over 15 years. (assume monthly payments)
Adjustable Rate – Tied to the U.S. T-Bill rate, which is
estimated to be 2.8% in Yr 1 and 3.1% in Yr 2. After the first 2
years,...
You are considering a creative financing arrangement for the purchase of a small apartment complex. The...
You are considering a creative
financing arrangement for the purchase of a small apartment
complex. The property is selling for $2,600,000. Both lenders have
agreed to allow the arrangement to proceed, if you decide to pursue
it. The first mortgage will be for 65% LTV over 25 years with
monthly payments at 9%. The first mortgage charges a 0.5%
origination fee and no points. The second mortgage will be for 20%
LTV over 10 years with monthly payments at 15%....
A tourist company is borrowing money from FundingParner to purchase a yacht to use in expeditions...
A tourist company is borrowing money from FundingParner to
purchase a yacht to use in expeditions with customers. The purchase
price of the boat is NOK 5 million, and the acquisition will be
financed 80% with debt. The loan will be secured by 1st priority
pledge in the boat. The tenor of the loan will be 5 years, but the
loan will have a 10-year repayment profile such that 400 000 of the
loan will be repaid each year. The...
You are planning to purchase a condo that costs $480,000. You plan to put 20% down and borrow the remainder.
You are planning to purchase a condo that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.25% on a 30-year mortgage.
Use function “PV” to calculate the loan amount given a payment of $1550 per month. What is the most that you can borrow? (Be sure that PV is the amount you borrow, not the cost of the house.)
Use function “PMT” to calculate your...
You plan to borrow $40,000 from the bank to pay for inventories for a gift shop...
You plan to borrow $40,000 from the bank to pay for inventories
for a gift shop you have just opened. The bank offers to lend you
the money at 14 percent annual interest for the 3 months the funds
will be needed (assume a360-day year).
a. Calculate the annualized rate of interest on the loan.
b. In addition, the bank requires you to maintain a 15 percent
compensating balance in the bank. Because you are just opening
your business, you...
You plan to borrow $10,000 from the bank to pay for inventories for a gift shop...
You plan to borrow $10,000 from the bank to pay for inventories
for a gift shop you have just opened. The bank offers to lend you
the money at 8 percent annual interest for the 3 months the funds
will be needed (assume a 360-day year). a. Calculate the
annualized rate of interest on the loan. b. In addition, the bank
requires you to maintain a 14 percent compensating balance in the
bank. Because you are just opening your business,...
You plan to borrow $50000 from the bank to pay for inventories for a gift shop...
You plan to borrow $50000 from the bank to pay for inventories
for a gift shop you have just opened. The bank offers to lend you
the money at 9 percent annual interest for the
3 months the funds will be needed (assume a 360-day year).
a. Calculate the annualized rate of interest on the loan.
b. In addition, the bank requires you to maintain a 20 percent
compensating balance in the bank. Because you are just opening
your business,...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Cost of Production Report Hana Coffee Company roasts and packs coffee beans. The process begins by...
- C++ Task: You are to write a class called Monomial, using filenames monomial.h and monomial.cpp, that...
- Partial Pressure/Total Pressure Question Consider the equation: (CH3)2N2H2(l) + 2N2O4(l) ---> 3N2(g) + 4H2O(g) + 2CO2(g)...
- Can you show how to do this step by step using Matlab please. Write a function...
- Plaintiff died of gas asphyxiation when he entered a sewer tunnel without a mask to answer...
- Retail Co has a unique set of HR practices. Describe and evaluate how you think the...
- Discuss some of the ways artists experimented with new styles and techniques, and how these differed...
ADVERTISEMENT