You took a $35,000, 3-year equal payment loan (a.k.a. mortgage loan) at 4% APR with monthly...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You took a $35,000, 3-year equal payment loan (a.k.a. mortgage loan) at 4% APR with monthly payments. a. (2 points) Complete the amortization table. Do not use PPMT, IPMT functions. b. (1 point) Compute the 5th principal payment and interest payment. Use the PPMT and IPMT functions to answer the question. 1 c. (0.5 point) Draw a graph of the interest payments, principal repayments, and total payments of the loan over the loan period using a mix of column and line charts. X-values: Months Y values: three series mentioned above - Column chart: total payments Line chart: principal repayments and interest payments (.25 pt) Add a legend to the graph. A 1 Loan amount Loan term 2 (years) 3 4 5 6 a) 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Interest rate (APR) 34 35 36 37 38 39 40 41 42 Month wwwNNNNNNGAN CONSGAEN B 35,000 3 4.00% Loan beginning balance Interest Principal payment payment b) 5TH payments principal repayment interest payment total payment Total payment answer Loan ending balance formulatext Loan beginnin 9 balance Interest payment formulatext Principal payment Total payment Loan ending balance You took a $35,000, 3-year equal payment loan (a.k.a. mortgage loan) at 4% APR with monthly payments. a. (2 points) Complete the amortization table. Do not use PPMT, IPMT functions. b. (1 point) Compute the 5th principal payment and interest payment. Use the PPMT and IPMT functions to answer the question. 1 c. (0.5 point) Draw a graph of the interest payments, principal repayments, and total payments of the loan over the loan period using a mix of column and line charts. X-values: Months Y values: three series mentioned above - Column chart: total payments Line chart: principal repayments and interest payments (.25 pt) Add a legend to the graph. A 1 Loan amount Loan term 2 (years) 3 4 5 6 a) 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Interest rate (APR) 34 35 36 37 38 39 40 41 42 Month wwwNNNNNNGAN CONSGAEN B 35,000 3 4.00% Loan beginning balance Interest Principal payment payment b) 5TH payments principal repayment interest payment total payment Total payment answer Loan ending balance formulatext Loan beginnin 9 balance Interest payment formulatext Principal payment Total payment Loan ending balance
Expert Answer:
Answer rating: 100% (QA)
Here is the graph with a mix of column and line charts showing the interest payments principal repay... View the full answer
Related Book For
Fixed Income Securities Valuation Risk and Risk Management
ISBN: 978-0470109106
1st edition
Authors: Pietro Veronesi
Posted Date:
Students also viewed these accounting questions
-
17 18 19 20 21 22 23 7285 24 26 The original coordinates of the point in polor coordinates are X'-r cos (+0) and Yor cos (+0) 29 30 A decoder is a combinational circuit that converts binary...
-
123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 200 210 230 260 280 200 210 230 260 280 Twenty-four individuals were analyzed for 2 microsatellite markers. The experiment involved DNA...
-
? ????????? 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 50 Use your 44 use is 45 46 47 48 49 Made sales of product Cost for the inventory that was sold Amount of the invoice (above) that returns and...
-
Question 4: Partners M, N, and O agreed to share the net income or loss in the ratio of 5:4:3 respectively. Their capital balances were Rs.80, 000, Rs. 70, 000 and Rs. 60, 000. They decided that "O"...
-
You are an economic adviser to the government of China in 2008. The country has a current account surplus and is facing gathering inflationary pressures. a. Show the location of the Chinese economy...
-
118. Match the following columns. Column-I Column-II A Ladybird () Methanobacterium B Mycorrhiza (II) Trichoderma C Biological control (III) Aphids D Biogas (IV) Glomus (1) A-2 B-4; C-3; D-1 (2) A-3;...
-
Explain the reason why it is convenient to represent the bicubic spline in the form \[\operatorname{spline}(K, T)=\sum_{i=1}^{p} \sum_{j=1}^{q} c_{i j} M_{i}(K) N_{j}(T)\] where \(M_{i}(K), i=1,...
-
A radio tower rises to height h above flat horizontal ground. At the top is a magnetic dipole antenna, of radius b, with its axis vertical. FM station KRUD broadcasts from this antenna at angular...
-
The Gryffin Company started operations this year and reported the following information at the end of the year (i.e. ending balances after all transactions have already been recorded and summarized):...
-
Smoke alarms with a UL label have been certified to last 10 years (Source: Underwriters Laboratories). Assume the lifetimes of smoke alarms with a UL label are normally distributed with mean 10.8...
-
Given |X - XI
-
The book basis of depreciable assets for Erwin Co. is 900,000 and the tax basis is 700,000 at the end of 2015. The enacted tax rate is 34% for all periods. Determine the amount of deferred taxes to...
-
Where in the financial statements are preference shares normally reported?
-
Simonis Company, which uses IFRS, has a note receivable with a carrying value of $30,000 at December 31, 2015. On January 2, 2016, the borrower declares bankruptcy, and Simonis estimates that only...
-
Identify the five steps in the revenue recognition process.
-
How are current liabilities related to a companys operating cycle?
-
Cornelius Company produces women's clothing. During the year, the company incurred the following costs: Factory rent Direct labor Utilities-factory Purchases of direct materials Indirect materials...
-
Flicker, Inc., a closely held corporation, acquired a passive activity this year. Gross income from operations of the activity was $160,000. Operating expenses, not including depreciation, were...
-
Today is November 3, 2008 and you have available only the cap data in Table 19.4. Consider a European, 1-year at-the-money swaption on a 3-year swap. (a) Use the Ho-Lee model to compute the price of...
-
In Chapters 2 (Section 2.8) and 3 (Section 3.7) we analyzed the risk and return of the Orange County portfolio, using the building blocks of zero coupon bonds and duration in this exercise, we...
-
You are worried about interest rate volatility. You decide to hedge your portfolio with a 3-year coupon bond paying 4% on a semiannual basis. (a) How much should you go short/long on this bond in...
-
A golf ball is hit from the tee and travels above level ground. Accounting for air resistance, where is the horizontal location of the peak of the flight: at a position that is less than half the...
-
The velocity of an object is given in SI units by \(\vec{v}=\left(a t-b t^{2} ight) \hat{\imath}+c \hat{\jmath}\), with \(a=14 \mathrm{~m} / \mathrm{s}^{2}, b=10 \mathrm{~m} / \mathrm{s}^{3}\), and...
-
A cannon fires a shell at an angle such that the shell's initial velocity has a horizontal component of \(20 \mathrm{~m} / \mathrm{s}\) and a vertical component of \(35 \mathrm{~m} / \mathrm{s}\)....
Study smarter with the SolutionInn App