E32 fx =PMT(E25/E30,48,-B22)+PMT(E29/E30,120,B22) B E F 8 9 Start by looking up rates to use as...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
E32 fx =PMT(E25/E30,48,-B22)+PMT(E29/E30,120,B22) B E F 8 9 Start by looking up rates to use as APRS on the Mortgage Rates tab which contains historical data of 30-year fixed mortgage rates. (When looking up your Month and Year use the week given. For example, if your APR Year and APR Month are 1977 and 5 use the percentage for 10 5/6/1977-8.78%.) 11 12 APR Year 13 APR Month 14 Interest Rate 2000 11 7.05% 2015 3 3.89% 1974 6 9.09% 15 16 17 4 Now, using the Student Loan Amount given below, perform each of the calculations indicated. Refer to the Financial formulas section 18 provided on the Instructions Word document as needed. 19 20 Format all financial amounts as Currency with the $ symbol and 2 decimal places, and all n and t entries as Number with 0 decimals. 21 22 Student Loan Amount $32,746.00 23 4a Subsidized Student Loan (determine the monthly payment required for a 10-year loan) 24 Total principal amount to repay (P) $32,746.00 25 26 Your APR (r) 7.1% Number of payments per year (n) 12 27 28 Number of years (t) 10 The monthly loan payment (PMT) ($381.05) 29 30 Total amount paid to the loan ($45,726.38) 31 Interest paid on loan ($12,980.38) 32 33 34 35 36 37 38 39 40 41 4b Unsubsidized Student Loan (determine the monthly payment required for a 10-year loan that accrued simple interest while in school for 4 years) Your APR for interest accrued while in school Number of years (t) while in school Additional interest accrued while in school Total principal amount to repay (P) Your APR (r) Number of payments per year (n) Number of years (t) The monthly loan payment (PMT) Total amount paid to the loan Interest paid on loan 3.9% 4 $1,938.82 $32,746.00 9.1% 12 10 321.3537932 38562.45518 $5,816.46 Student Loans Start by looking up the mortgage rates for the given months and years. Enter your rate as a percentage. Example: 4.03 should be entered as 4.03% Use the provided Student Loan Amount to complete parts 4a (subsidized loan) and 4b (unsubsidized loan). PMT P*(r/n)/(1 - (1 + r/n)^(-n*t)) Total amount paid to the loan = PMT*n*t Interest paid on loan = Total amount paid to the loan - Total principal amount to repay Interest accrued while in school follows simple interest: I=P*r*t 4a Subsidized Student Loan (determine the monthly payment required for a 10-year loan) Total principal amount to repay (P) Your APR (r) Number of payments per year (n) Number of years (t) The monthly loan payment (PMT) Total amount paid to the loan Interest paid on loan $32,738.00 10.4% 12 10 $439.74 $52,768.34 $20,030.34 4b Unsubsidized Student Loan (determine the monthly payment required for a 10-year loan that accrued simple interest while in school for 4 years) Your APR for interest accrued while in school Number of years (t) while in school Additional interest accrued while in school Total principal amount to repay (P) Your APR (r) Number of payments per year (n) Number of years (t) 4.4% 4 $5,748.79 $38,486.79 6.6% 12 10 The monthly loan payment (PMT) Total amount paid to the loan Interest paid on loan $438.38 $52,605.81 $14,119.02 E32 fx =PMT(E25/E30,48,-B22)+PMT(E29/E30,120,B22) B E F 8 9 Start by looking up rates to use as APRS on the Mortgage Rates tab which contains historical data of 30-year fixed mortgage rates. (When looking up your Month and Year use the week given. For example, if your APR Year and APR Month are 1977 and 5 use the percentage for 10 5/6/1977-8.78%.) 11 12 APR Year 13 APR Month 14 Interest Rate 2000 11 7.05% 2015 3 3.89% 1974 6 9.09% 15 16 17 4 Now, using the Student Loan Amount given below, perform each of the calculations indicated. Refer to the Financial formulas section 18 provided on the Instructions Word document as needed. 19 20 Format all financial amounts as Currency with the $ symbol and 2 decimal places, and all n and t entries as Number with 0 decimals. 21 22 Student Loan Amount $32,746.00 23 4a Subsidized Student Loan (determine the monthly payment required for a 10-year loan) 24 Total principal amount to repay (P) $32,746.00 25 26 Your APR (r) 7.1% Number of payments per year (n) 12 27 28 Number of years (t) 10 The monthly loan payment (PMT) ($381.05) 29 30 Total amount paid to the loan ($45,726.38) 31 Interest paid on loan ($12,980.38) 32 33 34 35 36 37 38 39 40 41 4b Unsubsidized Student Loan (determine the monthly payment required for a 10-year loan that accrued simple interest while in school for 4 years) Your APR for interest accrued while in school Number of years (t) while in school Additional interest accrued while in school Total principal amount to repay (P) Your APR (r) Number of payments per year (n) Number of years (t) The monthly loan payment (PMT) Total amount paid to the loan Interest paid on loan 3.9% 4 $1,938.82 $32,746.00 9.1% 12 10 321.3537932 38562.45518 $5,816.46 Student Loans Start by looking up the mortgage rates for the given months and years. Enter your rate as a percentage. Example: 4.03 should be entered as 4.03% Use the provided Student Loan Amount to complete parts 4a (subsidized loan) and 4b (unsubsidized loan). PMT P*(r/n)/(1 - (1 + r/n)^(-n*t)) Total amount paid to the loan = PMT*n*t Interest paid on loan = Total amount paid to the loan - Total principal amount to repay Interest accrued while in school follows simple interest: I=P*r*t 4a Subsidized Student Loan (determine the monthly payment required for a 10-year loan) Total principal amount to repay (P) Your APR (r) Number of payments per year (n) Number of years (t) The monthly loan payment (PMT) Total amount paid to the loan Interest paid on loan $32,738.00 10.4% 12 10 $439.74 $52,768.34 $20,030.34 4b Unsubsidized Student Loan (determine the monthly payment required for a 10-year loan that accrued simple interest while in school for 4 years) Your APR for interest accrued while in school Number of years (t) while in school Additional interest accrued while in school Total principal amount to repay (P) Your APR (r) Number of payments per year (n) Number of years (t) 4.4% 4 $5,748.79 $38,486.79 6.6% 12 10 The monthly loan payment (PMT) Total amount paid to the loan Interest paid on loan $438.38 $52,605.81 $14,119.02
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
The following medical office building is 10 years old and its short-lived items are listed in the following table. What is the percentage depreciation of all the short lived items?
-
answer all questions as instructed below. attend all questions. 4 Computer Vision (a) Explain why such a tiny number of 2D Gabor wavelets as shown in this sequence are so efficient at representing...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
On 1 July 2018 Bear Ltd acquired 100 000 shares in Island Ltd at a price of $10 each. There were brokerage fees of $1500. The closing market price of Island Ltd shares on 30 June 2019which is the...
-
Muriel likes her job, but her boss gives lousy bonuses. Muriel was recently offered a new job with better rewards, and her friend wants to know if she intends to take it. It depends on whether the...
-
If a taxpayer loses a case against the IRS in one of the three trial courts, does the taxpayer have any avenue for appeals?
-
Bryon Ltd has held 1,500,000 shares in Carlyle Ltd for many years. At the date of acquisition, the reserves of Carlyle Ltd amounted to 800,000. On 31 March 2006 Carlyle Ltd bought 400,000 shares in...
-
Figure 17.11 shows a sharp decline of the M1 money multiplier in 2008. What caused the drop? Using the indicators for currency (FRED code: CURRENCY), total reserve balances maintained (FRED code:...
-
Georgia Department of Education Georgia Standards of Excellence Framework GSE Geometry Unit 4 Part 2: The Segment Theorems Graphic Organizer In the remaining items of this task, we will work with the...
-
The chance of an IRS audit for a tax return with over $25,000 in income is about 2% per year. Suppose that 100 people with tax returns over $25,000 are randomly picked. We are interested in the...
-
Under the Internal Revenue Code, large companies are generally required to: Capitalize more period costs as product costs as an inventory cost for tax purposes under the IRC than would be required...
-
At the end of the current year, Accounts Receivable has a balance of $600,000; Allowance for Doubtful Accounts has a debit balance of $5,500; and sales for the year total $2,700,000. Bad debt expense...
-
Marvel Parts, Incorporated, manufactures auto accessories including a set of seat covers that can be adjusted to fit most cars. According to its standards, the factory should work 1,000 hours each...
-
Define material and nonmaterial culture. Give an example of howmaterial culture changes society and human interaction. Try to comeup with unique examples.
-
At the end of the current year, Accounts Receivable has a balance of $705,000; Allowance for Doubtful Accounts has a debit balance of $6,500; and sales for the year total $3,170,000. Using the aging...
-
Part 1 The following balances have been taken from the general ledger for Pak Fan Manufacturing Company: Raw Materials Inventory (1-12-2014) Rs. 40,000 Raw Material Purchases 190,000 Raw Materials...
-
Should U.S. antidumping laws be stated in terms of average total costs or average variable costs?
-
What risks are involved in an LBO?
-
Explain why an LBO is a type of capital reduction.
-
Can an LBO be carried out on a startup company?
Study smarter with the SolutionInn App