User Account

All Pages

Set up the loan amortization tables for the loans

Assignment Help Business Management
Reference no: EM132395295

Suppose that you plan to borrow $20,000 student loans to attend UM-Dearborn. You are considering borrowing the loan from SallieMae. SallieMae 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-Dearborn 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?

Reference no: EM132395295

Questions Cloud

Rapidly changing from myriad of demographics : The contemporary workforce is rapidly changing from a myriad of demographics. The effective leader must be skilled in managing the diverse workforce
What is wei current stock price : Wei's required return (rs) is 12.00%. What is Wei's current stock price? Show formula and work.
Pvifa determine the annual payment : Using PVIFA determine the annual payment on a $600,000, 10 percent, business loan from a commercial bank that is to be amortized over a five-year period.
Monthly fixed cost assigned to doing procedure : How many procedures per month, rounding up to the next highest whole number if necessary, would it need to do? (Show your work as partial credit will be given)
Set up the loan amortization tables for the loans : 1) Set up the loan amortization tables for the loans with these two different repayment options, respectively.
Strategic plan-related to specified health care organization : Construct 3 to 5-year strategic plan that is related to specified health care organization of your choice. The organization may be not-for-profit or for-profit.
How does the capital asset pricing model : How does the Capital Asset Pricing Model (CAPM) assists in measuring both risk and return, and calculating the weighted average costs of capital (WACC)?
What is the capital asset pricing model : What is the Capital Asset Pricing Model (CAPM). Identify the benefits and drawbacks of using the CAPM.
What is capital budgeting : What is capital budgeting? Explain how it promotes the financial health of an organization.

Reviews

Write a Review

Business Management Questions & Answers

  Medium-to-large aviation-related enterprise

You are working for a medium-to-large aviation-related enterprise and thanks to your ERAU College of Business degree, you have substantial knowledge of Information Systems. Because of your expertise, you were placed in a mid-to-upper level managem..

  What is the net income for this firm

Billy's Exterminators, Inc., has sales of $752,000, costs of $312,000, depreciation expense of $64,000, interest expense of $42,000, and a tax rate of 35 percent. What is the net income for this firm?

  What is the world trade organization

What is the World Trade Organization. Why are protests frequently held against what the WTO represents. Research websites and publications that support and dispute the aims of the WTO and explain the role and purpose of the organization for a gene..

  Have you ever engaged in social loafing while on a team

Have you ever engaged in social loafing while on a team? Why or why not? How does working effectively on a team give you an advantage in the workplace? How do groups normally develop?

  Explain your reasoning as you formulate your formal response

Your Discussion post as they serve only to begin your thinking process; however, you must explain your reasoning as you formulate your formal response.

  Recommend the key decision-making criteria

From the scenario for Katrina's Candies, determine the relevant costs for the expansion decision, and distinguish between the short run and the long run costs.

  Perform a distributed denial of-service attack

Explain how to use the three-way TCP handshake protocol to perform a distributed denial of-service attack

  What are some difference and similarities of java

In your opinion which would you prefer to use? If some code snippets could be provided as examples that would be helpful.

  Control and rigid structure to ensure success

In today's world of business, there is a lot of success based on the approach of management.

  Describe the primary industry or level of government

Identify whether it is a government or commercial organization. Describe the primary industry or level of government.

  Withdrawal at the end of the year of her last withdrawal

Your aunt has $500,000 invested at 5.5%, and she now wants to retire. She wants to withdraw $45,000 at the beginning of each year, beginning immediately.

  Discuss the challenges faced by the colombian coffee growers

Discuss the challenges faced by the Colombian coffee growers. What are the advantages of manual harvesting for the Colombian coffee growers?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd