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.

Provide the answer in Excel and show the formula please

Solutions

Expert Solution

jeff jeffy answered 1 year ago
Next > < Previous

Related 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
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...
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 a​360-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
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT