1.Attempt ALL questionsHugh is in his final year of study and forecast that it will cost $1,400,000 tocover tuition and boarding. He plans to finance 85% of the required amount with a4-year loan from his local commercial bank. The loan is at a 16.5% annual rateand compounds monthly.2.a)Using Excel, compute the monthly payment required to clear the loanwithin the projected period.b) Using Excel, prepare the amortization spreadsheet (show formulas).How much interest would Hugh have paid at the end of two and halfc)years?d)What proportion of the 25th payment is interest?e) What is the effective rate being charged by the commercial bank?You are planning to buy a parcel of land costing $3,750,000. You have saved $1250 000 as a down payment. You plan to borrow the balance from your buildingsociety at a rate of 13.5%, to be repaid annually over a 6-year period. The firstpayment is to be made immediately3.a) Using Excel, compute the annual paymentb) Using Excel, prepare the amortization schedulec)If you elected to pay off the balance of the loan at the end of the fourthyear, how much would you have to pay?Janet applied for a loan from her credit union. The annual interest rate is 19%.She plans to repay it over 6.5 years, paying $22 800 monthly.a)How much did Janet borrow?b) Prepare the loan amortization schedule for the first year.c) Compute the effective annual rate of the loan.

“Since you have posted multiple questions, we will provide the solution only to the first question…

1. Hugh is in his final year of study and forecast that it will cost $1,400,000 to cover tuition and boarding. He plans to finance 85% of the required amount with a 4-year loan from his local commercial bank. The loan is at a 16.5% annual rate and compounds monthly. a) Using Excel, compute the monthly payment required to clear the loan within the projected period. b) Using Excel, prepare the amortization spreadsheet (show formulas). c) years? How much interest would Hugh have paid at the end of two and half d) What proportion of the 25" payment is interest? e) What is the effective rate being charged by the commercial bank?

1. Hugh is in his final year of study and forecast that it will cost $1,400,000 to cover tuition and boarding. He plans to finance 85% of the required amount with a 4-year loan from his local commercial bank. The loan is at a 16.5% annual rate and compounds monthly. a) Using Excel, compute the monthly payment required to clear the loan within the projected period. b) Using Excel, prepare the amortization spreadsheet (show formulas). c) years? How much interest would Hugh have paid at the end of two and half d) What proportion of the 25" payment is interest? e) What is the effective rate being charged by the commercial bank?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

After graduation, you decide that you can pay $203.24 per month extra on your student loan ( standard monthly payment is 302.99), which has a balance of $50,000 and 20 years of monthly payments remaining. The annual interest rate on the loan is 4% How many years early will you be able to pay off the loan? Please answer in excel.
You are interested in saving for a trip when you graduate in three years. You can save $75 each of the next 36 months and earn 2.75% interest on your money. How much money would you have in your savings account in 36 months for your trip? ( Please reference the loan infromation in the "Task 5 Data " cells as the argument for your functions
THE PICTURE IS THE EXCEL TEMPLATE YOU MUST FILL OUT Suppose that you borrowed $25,000 student loans from Sallie Mae to attend UM - Dearborn. Once you graduate, you are required to start paying your loan and interest. The APR for your loan is 5.54%. Each month you will have to make interest payment and principal repayment. Suppose that you can choose the following two repayment plans: Standard repayment plan: if you choose this plan, you will have to pay off your loan in 10 years with the same amount of payment each month. Fixed extended repayment plan: if you choose this plan, you will be allowed to pay off your loan in 25 years with the same amount of payment each month. 1. Please use Excel to work on the following questions: How much should you pay each month for these two plans? • Set up the loan amortization tables for these two plans. How much interest will you pay in total when you pay off your loan for these two plans? • Amortization Schedule for your Student Loan (Standard…
Suppose that you take out an unsubsidized Stafford loan on September 1 before your junior year for $45004500 and plan to begin paying it back on December 1 after graduation and grace period 27 months later. The interest rate is 6.8%. How much of what you will owe will be interest?$Round your answer to the nearest cent.
Create an Amortization schedule-see amortization video. How much student debt will I bear by the time I graduate? What will my student loan payments be? a. My undergraduate student debt is $32,500. I have secured a 4.08% annual rate (EAR) for a 25-year loan, identify the monthly payment. b. What is the total amount of interest paid on this loan? c. In total (interest plus principle) how much did you pay for this $32,500 loan?
You have an outstanding student loan with required payments of $500 per month for the next four years. The interest rate on the loan is 9.00% APR (monthly). You are considering making an extra payment of $200 today (i.e., you will pay an extra $200 that you are not required to pay). If you are required to continue to make payments of $500 per month until the loan is paid off, what is the amount of your final payment? What effective rate of retum (expressed as an APR with monthly compounding) have you eamed on the $200? (Note: Be careful not to round any intermediate steps less than six decimal places.) If you are required to continue to make payments of $500 per month until the loan is paid off, what is the amount of your final payment? The final payment is $ (Round to the nearest cent.)
You have an outstanding student loan with required payments of $600 per month for the next 4 years. The interest rate on the loan is 9.50% APR (monthly). You are considering making an extra payment of $100 today (i.e., you will pay an extra $100 that you are not required to pay). If you are required to continue to make payments of $600 per month until the loan is paid off, what is the amount of your final payment? What effective rate of return (expressed as an APR with monthly compounding) have you earned on the $100? (Note: Be careful not to round any intermediate steps less than six decimal places.) If you are required to continue to make payments of $600 per month until the loan is paid off, what is the amount of your final payment? The final payment is $ (Round to the nearest cent.)
You have an outstanding student loan with required payments of $500 per month for the next four years. The interest rate on the loan is 8% APR. You are considering making an extra payment of $150 today (that is, you will pay an extra $150 that you are not required to pay). If you are required to continue to make payments of $500 per month until the loan is paid off, what is the amount of your final payment? What effective rate of return (expressed as an APR with monthly compounding) have you earned on the $150? Now that you realize your best investment is to prepay your student loan, you decide to prepay as much as you can each month. Looking at your budget, you can afford to pay an extra $300 per month in addition to your required monthly payments of $500, or $800 in total each month. How long will it take you to pay off the loan?
Starting next year, you will need $15,000 annually for 4 years to complete your education. (One year from today you will withdraw the first $15,000.) Your uncle deposits an amount today in a bank paying 5% annual interest, which will provide the needed $15,000 payments. How large must the deposit be? Do not round intermediate calculations. Round your answer to the nearest cent. $ How much will be in the account immediately after you make the first withdrawal? Do not round intermediate calculations. Round your answer to the nearest cent. $
You have an outstanding student loan with required payments of $500 per month for the next four years. The interest rate on the loan is 9% APR (monthly). You are considering making an extra payment of $200 today (that is, you will pay an extra $200 that you are not required to pay). If you are required to continue to make payments of $500 per month until the loan is paid off, what is the amount of your final payment? What effective rate of return (expressed as an APR with monthly compounding) have you earned on the $200? STER If you are required to continue to make payments of $500 per month until the loan is paid off, what is the amount of your final payment? The amount of your final payment is $ (Round to the nearest cent.) What rate of return (expressed as an APR with monthly compounding) have you earned on the $2007 Effective rate is%. (Round to the nearest integer.)
Suppose that after the 6-month grace period after you graduate college, you have $63,000 in student loan debt. If you plan on paying back your loans using the standard repayment plan, you will be paying your loans off in 10 years. You may assume an interest rate of 5.05% which will compound daily. In order to find your monthly payment, you will first need to find your daily payment since the interest is compounded daily. What is your daily payment? [Select] What is your monthly payment for a month with 30 days? [Select]
Please explain how to do this in Excel. Please explain how you did it and what the results mean.You plan to buy a house in December 2023. The sale price is $650,000. You need to pay 20% down payments and borrow the additional 80% from Bank of America with a 30-year, 7.2% fixed-rate mortgage loan. You need to pay an equal MONTHLY payment starting from January 1, 2024, for a total of 30 years. (1) Calculate your expected monthly mortgage payment. (2) Develop the full amortization table for your mortgage loan. (3) When you prepare your 2024 tax filing, what is the total mortgage interest payment that you can consider for the tax deduction?