Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help Questions: Suppose that you plan to borrow $20,000 student loans to attend UM-Dearbom. You are considering borrowing the loan from SallicMac. Sallic Mac

image text in transcribed

please help

Questions: Suppose that you plan to borrow $20,000 student loans to attend UM-Dearbom. You are considering borrowing the loan from SallicMac. Sallic Mac offers two options for the repayment of your loan. One is the deferred repayment option and the other is interest repayment option. The APR for the deferred repayment option is 5.75% and the APR for the interest repayment option is 4.75%. You plan to finish your undergraduate study in UM-Dearbom within four years. The two repayment options are described as below Deferred repayment option: You make no scheduled student loan payments for 4 years while you are in school and in 1 year of the grace period after you graduate. However, the unpaid interest every month will be added to your principal amount at the end of your grace period. After the grace period, the total amount your will pay will be equal to the principal you borrow and the accumulated unpaid interest. Each month you will be required to pay the same amount, which includes interest and the required principal repayment. You are required to completely pay off your loan within 10 years, Interest repayment option: You pay interest every month when you are in school and in grace period. After the grace period, you will start to pay the principal of the loan. Each month you will be required to pay the same amount, which includes interest and the required principal repayment You are required to completely pay off your loan within 10 years. 1. Please use Excel to work on the following questions: 1) Set up the loan amortization tables for the loans with these two different repayment options, respectively, 2) How much interest will you pay in total when you pay off your loan offered by these two different repayment options, respectively? 3) How much will you pay in total, including interest and principal, for these two different repayment options, respectively? 2. Write one-page memo to summarize your results obtained in the first question and discuss which repayment option you would like to choose. You can address the memo to Prof. Xie

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Adventure Finance

Authors: Aunnie Patton Power

1st Edition

3030724271, 978-3030724276

More Books

Students also viewed these Finance questions

Question

KEY QUESTION Refer to the table in question

Answered: 1 week ago