Question

TURN YOUR ANSWER IN EXCEL. You borrow $100,000 for four years, at 3.5% per year. You...

 

TURN YOUR ANSWER IN EXCEL.

You borrow $100,000 for four years, at 3.5% per year. You will make your payments yearly. First get the payment using your calculator and or Excel. Then construct a Loan Amortization Schedule using Excel

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are the loan officer of a bank. The ABC Company wants to borrow $100,000 and...
You are the loan officer of a bank. The ABC Company wants to borrow $100,000 and repay it with four equal annual payments (first payment due one year from now). You decide that the ABC Company should pay 0.10 per year on the loan. a. What is the annual payment? b. Complete the following debt amortization table: Period Amount owed(beginnig of yr) Interest Principal Amount owed(end of yr) 1 $100,000 2 3 4 c. What would be the annual payment...
Jimmy Herring can borrow $100,000 for three years at 8.0% interest with monthly payments based on...
Jimmy Herring can borrow $100,000 for three years at 8.0% interest with monthly payments based on a 30-year amortization. Assume twelve 30-day months in a year, payments always made on the first day of the month and monthly accrual of interest. Create an interactive amortization schedule in Excel that contains an input menu and that shows monthly payments, monthly interest, monthly principal and the ending monthly balance in columns. Beginning and ending dates do not matter at this point –...
Using Excel You have just turned 35, and you intend to start saving for your retirement....
Using Excel You have just turned 35, and you intend to start saving for your retirement. Once you retire in 30 years (when you turn 65), you would like to have an income of $100,000 per year for the next 20 years. Calculate how much you would have to save between now and age 65 in order to finance your retirement income. Make the following assumptions: • All savings draw compound interest of 10% per year. • You make the...
If you borrow $1,800 and agree to repay the loan in four equal annual payments at...
If you borrow $1,800 and agree to repay the loan in four equal annual payments at an interest rate of 10%, what will your payment be? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. What will your payment be if you make the first payment on the loan immediately instead of at the end of the first year? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Consider a 4-year amortizing loan. You borrow $2,900 initially and repay it in four equal annual...
Consider a 4-year amortizing loan. You borrow $2,900 initially and repay it in four equal annual year-end payments. a. If the interest rate is 9%, what is the annual payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Prepare an amortization schedule. (Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.)
You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local credit...
You plan to purchase a $130,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 5.25 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16)) Monthly payment $    b. Construct the amortization schedule for the first six payments. (Do not round intermediate calculations....
You borrow ​$300,000 to buy a house over a 15​-year term. The loan is structured as...
You borrow ​$300,000 to buy a house over a 15​-year term. The loan is structured as an amortized loan with annual payments and an interest rate of 10​%. Find the information for the amortization schedule for years 1 and 2. Payment​ ($) Interest in Payment​ ($) Principal Repaid​ ($) Principal Owing at End of Year​ ($)
Assume you borrow $50,000 at 10% per year in- terest and you agree to repay the...
Assume you borrow $50,000 at 10% per year in- terest and you agree to repay the loan in five equal annual payments. What is the amount of the unre- covered balance immediately after you make the third payment? both excel and hand solutions , please capture the excel solution.
The XYZ Company has borrowed $100,000. Payments will be made over a four-year period (first payment...
The XYZ Company has borrowed $100,000. Payments will be made over a four-year period (first payment at the end of the first year). The bank charges interest of 0.20 per year. a. The annual payment will be ________. b. The debt amortization schedule is Amount owed (beginning of period) Interest Principal 1 $100,000 2 3 4 c. If there are five payments with the first payment made at the moment of borrowing, the annual payment will be ________.
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per...
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment. How much is the annual total loan payment? How much interest is paid in the first year? How much total interest is paid over three years?