3. Create the necessary formulas to calculate the mortgage payment on a house purchase. a. You...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. Create the necessary formulas to calculate the mortgage payment on a house purchase. a. You will be financing, $500,000. b. Your yearly interest rate is 4%. c. This is a 30-year loan. Use PMT for your calculations. Create a tab 3 Example: Using a different loan amount of $ 800,000. Loan Amount 800,000.00 Annual Interest Rate Monthly interest Rate Number of Years Number of Payment Payment 4.25% 0.35% 30 360 ($3,935.52) 4. Perform goal seek on the above, use you could only afford payments of $2,000.00 a month what would you need the interest rate to be? Write your answer in a new tab 4, but do not save the goal seek results. Your answer should be the original interest rate. 3. Create the necessary formulas to calculate the mortgage payment on a house purchase. a. You will be financing, $500,000. b. Your yearly interest rate is 4%. c. This is a 30-year loan. Use PMT for your calculations. Create a tab 3 Example: Using a different loan amount of $ 800,000. Loan Amount 800,000.00 Annual Interest Rate Monthly interest Rate Number of Years Number of Payment Payment 4.25% 0.35% 30 360 ($3,935.52) 4. Perform goal seek on the above, use you could only afford payments of $2,000.00 a month what would you need the interest rate to be? Write your answer in a new tab 4, but do not save the goal seek results. Your answer should be the original interest rate.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The real interest rate is 4 percent, and the nominal interest rate is 6 percent. What is the anticipated rate of inflation?
-
1. (a) Below are the financial statements of TNTT Corporation: Financial Statement for the Year Ended December 2019 (Unit: Millions) Assets Current Assets Net Plant Total Assets Sales Cash Expenses...
-
Consider a call option with the following characteristics: Stock price: $90.32 Exercise price: $74.51 Risk-free rate: 5.9%, compounded continuously Maturity: 159 days (assume there are 365 days in a...
-
Examples using activity-based costing generally show that traditional costing systems ________ high-volume, less complex products and ________ low-volume, complex products undercost; overcost...
-
On January 1, 2015, Toms River Rafting, Inc. (TRR), has a deferred tax asset representing $250,000 in net operating loss carryforwards on its balance sheet. When it recognized this asset, TRR...
-
Write an if statement that assigns 10 to the variable b, and 50 to the variable c if the variable a is equal to 100.
-
In an examination of the Marco Corporation as at December 31, 19X2, you have learned that the following situations exist. No entries in respect thereto have been made in the accounting records. 1....
-
Western Family Steakhouse offers a variety of low-cost meals and quick service. Other than management, the steakhouse operates with two full-time employees who work 8 hours per day. The rest of the...
-
Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of...
-
1. What type of attitude scale is used by the ACSI if any? 2. What type of attitude study might you design if you were the consultant? 3. How would you use results from this approach to diagnose...
-
List all numbers from each set that are (a) natural numbers, (b) whole numbers, (c) integers, (d) rational numbers, (e) irrational numbers, (f) real numbers. - 2.3, 3 V3, 0. - 8 11, - 6, } EXAMPLE...
-
Find the general solution of the differential equation " + 2y - 3y = 0. y (x) =
-
How do emerging trends such as open innovation and crowdsourcing redefine traditional paradigms of collaboration, unlocking new opportunities for cross-sectoral synergy and co-creation ?
-
In what ways do emergent technologies facilitate the integration of disparate expertise for seamless collaboration in cutting-edge initiatives ?
-
Given the system of equations x' = -x+2y, y = 3x - 4y. Eliminate and write down the second-order equation satisfied by y.
-
What ethical considerations arise in collaborative research and development initiatives, particularly regarding data privacy, intellectual property rights, and equitable distribution of benefits ?
-
Apply the trade model to the following scenario: Two countries, China (C) and Indonesia (1) produce two goods, sneakers (S) and electronics (E) using unskilled labor and capital. . Production of...
-
Keating & Partners is a law firm specializing in labour relations and employee-related work. It employs 25 professionals (5 partners and 20 managers) who work directly with its clients. The average...
-
Define opportunity cost. What is your opportunity cost of attending a class at 11:00 a.m.? How does it differ from your opportunity cost of attending a class at 8:00 a.m.?
-
Explain how time lags in discretionary fiscal policymaking could thwart the efforts of Congress and the president to stabilize real GDP in the face of an economic downturn. Is it possible that these...
-
For each of the following situations, explain which of the policy issues discussed in this chapter is associated with the stance the institution has taken. a. The IMF extends a long-term loan to a...
-
A container of an organic liquid a $25^{\circ} \mathrm{C}$ has a mass of $1100 \mathrm{~kg}$ and a volume of $0.94 \mathrm{~m}^{3}$. Find the liquid's weight, its density, and its specific gravity.
-
A vertical, cylindrical tank with a diameter of $10 \mathrm{~m}$ and a depth of $4 \mathrm{~m}$ is filled to the top with water at $25^{\circ} \mathrm{C}$. If the water is heated to $60^{\circ}...
-
The system in Figure P1.6 is at $20^{\circ} \mathrm{C}$. If atmospheric pressure is $101.3 \mathrm{kPa}$ and the absolute pressure at the bottom of the tank is $264.1 \mathrm{kPa}$, what is the...
Corporate Finance And Investment Decisions And Strategies 5th Edition - ISBN: 0273695614 - Free Book
Study smarter with the SolutionInn App