Suppose that you plan to borrow $15,000 student loans to attend a university. You are considering...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose that you plan to borrow $15,000 student loans to attend a university. You are considering borrowing the loan from XYZ. XYZ 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 3.75% and the APR for the interest repayment option is 3.15%. You plan to finish your undergraduate study in university within five years. The two repayment options are described as below:Deferred repayment option: You make no scheduled student loan payments for 5 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. Suppose that you plan to borrow $15,000 student loans to attend a university. You are considering borrowing the loan from XYZ. XYZ 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 3.75% and the APR for the interest repayment option is 3.15%. You plan to finish your undergraduate study in university within five years. The two repayment options are described as below:Deferred repayment option: You make no scheduled student loan payments for 5 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.
Expert Answer:
Related Book For
Financial Management Principles and Applications
ISBN: 978-0133423822
12th edition
Authors: Sheridan Titman, Arthur Keown, John Martin
Posted Date:
Students also viewed these accounting questions
-
Suppose that you plan to buy a car and want to know whether a General Motors car is more reliable than a Ford. One way to find out is to ask owners of both cars how often their cars go into the shop...
-
Suppose that you plan to do a one-way MANOVA with 5 groups, using = .05. There are four outcome variables, and you want to have power of .70. For each of the following effect sizes, what minimum...
-
You plan to borrow $20,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 10 percent annual interest for the six months the funds...
-
The city pool loses 1.0 inch of water every week due to evaporation. If the pool is 25 yards long and 12 yards wide, what is the energy required to keep the pool at 15C. If the cost of energy is...
-
Read the opening case on Starbucks and then answer the following questions: a. Initially Starbucks expanded internationally by licensing its format to foreign operators. It soon became disenchanted...
-
NBM has $2 million of extra cash. It has two choices to make use of the cash. One alternative is to invest the cash in financial assets. The resulted investment income will be paid out as a special...
-
Discuss under what circumstances a nurse has a duty to question a patients care.
-
An XYZ April 2041 bond with a 5.5 percent coupon interest rate and a par value of $1,000 recently had a price of 95.625. Calculate the following: a. When will the bond mature? b. How much would you...
-
Melissa recently paid $660 for round-trip airfare to San Francisco to attend a business conference for three days. Melissa also paid the following expenses: $650 fee to register for the conference,...
-
In light of the successful turnaround do you think the federal bailout of GM was warranted What are the pros and cons after the fact Which factors that were pivotal to the sales rebound at GM were...
-
am (Comprehensive) i 5 :36:22 Ascending colon Transverse colon Rectum Cecum Label the features of the large intestine by clicking and dragging the labels to the correct location. Descending colon...
-
The University of Ottawa has just launched a new program specifically targeting those with an interest in coding. Demand for this program is huge, with significant interest amongst both potential...
-
Read and research about networking skills related to business. Discuss what you believe to be your 2 top networking skills. What skills would you like to acquire or enhance to help your business...
-
Key Skills are needed to have meaningful discussions with potential customers to better define and understand their needs. Identify one of these skills. Explain what it means and why it is important.
-
Using Facebook to do customer behavior analysis, Based on information gathered and their industry research, develop specific recommendations to add value to through integration of the customer value...
-
Analyze and evaluate a bloated government agency based on written case study. 1. Alternative Courses of Action - Decision Matrix 2. Conclusion/ Recommendation 3. Plan of Action answer 1 2 3 and below...
-
Maya, the owner of a small craft shop, inadvertently sold decorative wall hangings that included hazardous lead-based paint. The paint was a very small part of the finished product, and the crafts...
-
The Pletcher Transportation Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using...
-
On May 25, 2009, the stock of Emerson Electric (EMR) was trading for $32.18 per share, whereas the stock of its larger rival, the General Electric Corporation (GE), was trading for only $13.11....
-
Seven years ago, Lance Murdock purchased a wooden statue of a Conquistador for $7,600 to put in his home office. Lance has recently married, and his home office is being converted into a sewing room....
-
Dharma Supply has earnings before interest and taxes (EBIT) of $500,000, interest expenses of $300,000, and faces a corporate tax rate of 35 percent. a. What is Dharma Supplys net income? b. What...
-
A membrane separator is \(3 \mathrm{~mm}\) in diameter, and the membrane permeability was estimated as \(2 \times 10^{-6} \mathrm{~m} / \mathrm{s}\). The solute being transported has a diffusivity of...
-
Develop a simple backmixed model to evaluate the performance of a gas-separation system. Here a feed gas enters a high-pressure chamber with a mole fraction of A of \(x_{\mathrm{Af}}\) and leaves...
-
Pervaporation: a case-study problem. Pervaporation refers to removal of the permeate as vapor and represents an intermediate case between purely gas transport and purely liquid transport in a...
Study smarter with the SolutionInn App