TVO ILC is JWTHTM MTH1W Learning Activity 2.10 Assessment for Grading 11. The following table shows...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
TVO ILC is JWTHTM MTH1W Learning Activity 2.10 Assessment for Grading 11. The following table shows mortgage calculations on a spreadsheet. A person has set a maximum monthly payment that they can afford. The number of years over which they would have to repay the loan is displayed. B C D A 1 Loan Repayment 2 Monthly Repayment 980 3 Borrowed Principal 120,000.00 4 Loan Length 13 5 Period Rate 0.00322 Rate Period =RATE(12*B4,-B2, B3) a. Explain the components of the formula in cell D5, for the spreadsheet provided. b. What is the interest rate per period as a percent? TVO ILC is JWTHTM MTH1W Learning Activity 2.10 Assessment for Grading 11. The following table shows mortgage calculations on a spreadsheet. A person has set a maximum monthly payment that they can afford. The number of years over which they would have to repay the loan is displayed. B C D A 1 Loan Repayment 2 Monthly Repayment 980 3 Borrowed Principal 120,000.00 4 Loan Length 13 5 Period Rate 0.00322 Rate Period =RATE(12*B4,-B2, B3) a. Explain the components of the formula in cell D5, for the spreadsheet provided. b. What is the interest rate per period as a percent?
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
2. The long-term loan from World Bank had been taken out on 1 April 2018 to fund the company. According to the loan agreement, five annual installments of R36 000 are to be paid each year commencing...
-
Airlines sometimes offer reduced rates during certain times of the week to members of a businesspersons family if they accompany him or her on trips. How does the concept of relevant costs enter into...
-
What is meant by a sampling distribution? Why are sampling distributions important in attributes sampling?
-
When using Fleury's algorithm to find an Euler trail, never remove a _________________ unless it is the only option. Fill in the blank to make the statement true.
-
Kretz Corporation prepares monthly financial statements and therefore adjusts its accounts at the end of every month. The following information is available for March 2010: a. Kretz Corporation takes...
-
Jan . 1 Beginning inventory 1 3 0 units @$ 7 . 7 0 = $ 1 , 0 0 1 . 0 0 Jan. 1 0 Sold 6 0 units @ $ 1 6 . 2 0 = 9 7 2 . 0 0 Mar. 7 Purchased 3 7 0 units @$ 7 . 0 0 2 , 5 9 0 . 0 0 Mar. 1 5 Sold 1 2 0...
-
Swift Electronics manufactures and sells smartphones. Unfortunately, the company recently suffered serious fire damage at its home office. As a result, the accounting records for October were...
-
A stock analyst has come to the conclusion that three stocks have the following characteristics: Stock Expected Return Beta X 3% 0.20 And 4% 0.50 From 9% 1.20 1. Given this information, the analyst...
-
(30) Nelson Corporation sells three different products. The following information is available on December 31: Inventory Item Units X Y Z Cost per unit Net realizable value per unit 300 $4.00 $3.00...
-
What impacts young preschoolers (3-4 yrs. old) development seems unique for this age level? Provide supporting evidence and make obvious connections to your text/class content. How does development...
-
What are the various stages of the budgeting process, elaborate each step, which types of budgets are widely used, and address briefly the benefits and disadvantages of each.
-
Environmental issues, including climate change, are increasingly discussed in the executive suite as it relates to strategy formulation and implementation. Questions like how "green" a company should...
-
5 (6 points) The following tax information related to Aylmer Inc. Accounting income and Taxable income were the same for all years Year Income/ Tax (Loss) Rate Y2 33,000 30% Y3 47,000 33% Y4 16,000...
-
A city maintains a solid waste landfill that was 12 percent filled at the end of Year 1 and 26 percent filled at the end of Year 2. During those periods, the government estimated that total closure...
-
(Multiple IRRs) You observe the following project in the market. Your cost of capital is 10%: a. Should you take the project or reject it? Explain. b. What is the range of cost of capital for which...
-
(Multiple IRRs) You would like to open an investment company named Ripem. The cost of building up the company is $750,000. You offer your clients the following deal: For five annual deposits of...
-
Internal Control for Sales} Johnson Tires has three stores. Each store manager is paid a salary plus a bonus on the sales made by his or her store. On January 5, 2019, Kevin Samuel, manager of one of...
Study smarter with the SolutionInn App