Solve each problem using Excel. Show both the solution and the formula you used by putting...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Solve each problem using Excel. Show both the solution and the formula you used by putting an apostrophe in front of the equals sign. (Note: There is no template for this assignment. This assignment does not require that you understand the mechanics of the investment instruments. We will discuss investments later in the semester.) 5. An organization plans to take out a $375,000, 30-year mortgage with a 4.50% annual interest rate. The organization finds out it has the option of paying $19,800 in upfront fees to reduce the mortgage's annual interest rate to 3.85%. The organization can earn an annual return of 2.25% on any money it saves. a) Ignoring the upfront fees for now, how much will the organization save each month by choosing the option with the lower annual interest rate? (Hint: Mortgage payments are monthly cash outflows.) b) The organization decides to pay the upfront fees in order to have a lower annual interest rate. How many years will it take the organization to recover the upfront fees? (Hint: Treat the savings as a monthly cash inflow.) c) How much money will the organization save in total (in today's dollars) over the next 30 years? Solve each problem using Excel. Show both the solution and the formula you used by putting an apostrophe in front of the equals sign. (Note: There is no template for this assignment. This assignment does not require that you understand the mechanics of the investment instruments. We will discuss investments later in the semester.) 5. An organization plans to take out a $375,000, 30-year mortgage with a 4.50% annual interest rate. The organization finds out it has the option of paying $19,800 in upfront fees to reduce the mortgage's annual interest rate to 3.85%. The organization can earn an annual return of 2.25% on any money it saves. a) Ignoring the upfront fees for now, how much will the organization save each month by choosing the option with the lower annual interest rate? (Hint: Mortgage payments are monthly cash outflows.) b) The organization decides to pay the upfront fees in order to have a lower annual interest rate. How many years will it take the organization to recover the upfront fees? (Hint: Treat the savings as a monthly cash inflow.) c) How much money will the organization save in total (in today's dollars) over the next 30 years?
Expert Answer:
Answer rating: 100% (QA)
ANSWER AND EXPLANATION your reasoning for each part a Ignoring the upfront fees fo... View the full answer
Related Book For
Fundamental financial accounting concepts
ISBN: 978-0078025365
8th edition
Authors: Thomas P. Edmonds, Frances M. Mcnair, Philip R. Olds, Edward
Posted Date:
Students also viewed these finance questions
-
Solve each problem using the methods outlined in this chapter. 1. Solve for F1: 30.0F1 = (14.0) (18.0) + (25.0) (17.0) 2. Solve for Fw: (12.0) (15.0) + 45.0Fw = (21.0) (65.0) + (22.0) (32.0) 3. Two...
-
You are planning to take out a 5 hundred thousand dollar fixed-rate mortgage with a 30-year term and a stated annual mortgage rate of 5.7 percent. Your lender offers to lower your stated annual...
-
A young couple wishes to take out a sizeable home loan and, at the insistence of the bank, your client, asks the husband's elderly Chinese parents to guarantee the loan. The parents have very limited...
-
Why is Supplier Relationship is important to a business. explain
-
What were the motivations for the Federal Securities Acts of 1933 and 1934?
-
For Republic Services, Inc. company, inference on agency cost of debt can be made from recent debt offerings of the firm. If creditors are concerned about agency costs, then they will demand stricter...
-
How do patterns relate to reuse?
-
Three methods of interperiod income tax allocation have been advocated. These include (1) the asset/liability method, (2) the deferred method, and (3) the net-of-tax method. Required Define...
-
(a) Demonstrate how an interest rate swap can be valued in terms of bond prices.
-
Multiple Choice Questions: The operations manager for the Blue Moon Brewing Co. produces two beers: Lite (L) and Dark (D). Two of his resources are constrained: production time, which is limited to 8...
-
David Ortega is the lead researcher for an upscale restaurant group hoping to add another chain that would compete directly with the upscale Smith and Wollensky restaurants...
-
You are given the following probability distribution for CHC Enterprises: State of Economy Probability Rate of return Strong 0.25 21% Normal 0.55 5 Weak 0.20 -6 What is the stock's expected return?...
-
Speedy Travel produces car seats for children from newborn to 2 years old. The company is worried because one of its competitors has recently come under public scrutiny because of product failure....
-
Given the circuit diagram below, calculate a) the total resistance for the entire circuit b) the total current for the entire circuit c) the voltage across the 3-Ohm resistor 2Q m + V - 20V + V 3.02
-
A ball is dropped from the top of a 51.0 m -high cliff. At the same time, a carefully aimed stone is thrown straight up from the bottom of the cliff with a speed of 27.0 m/s. The stone and ball...
-
In the figure below, V = 10 V and R = R = R = R = 6.8. a) What is the equivalent resistance of the circuit? b) What is the current through each one of the four resistors? c) What is the power...
-
Given CDS spreads with the following tenors Tenor CDS Spread 1 1.0% 2 1.2% 3 1.4% 4 1.6% 1.7% 5 RN Default Prob Risk free rate of 5% flat continuously compounded and a recovery rate of 40%. What are...
-
A fuel pump sends gasoline from a car's fuel tank to the engine at a rate of 5.88 10-2 kg/s. The density of the gasoline is 735 kg/m3, and the radius of the fuel line is 3.18 10-3 m. What is the...
-
Jayroe Company was started when it issued bonds with $300,000 face value on January 1, 2013. The bonds were issued for cash at 103. They had a 15-year term to maturity and an 6 percent annual...
-
Supervalu, Inc., claims to be the largest publicly held food wholesaler in the United States. In addition to being a food wholesaler, it operates extreme value retail grocery stores under the name...
-
What is the difference between wages and salaries?
-
A lot of compensation information is available to employees today on the Web (e.g., www.salary.com), and much of it is inaccurate. How can an organization assure employees that they are fairly...
-
Flexible benefit plans are common today. Discuss ways in which employers can ensure that employees make good choices about the benefits and benefit levels that they choose within the benefits...
-
Payroll and benefits are commonly outsourced. Discuss which parts of PM, compensation, benefits, and payroll you would consider outsourcing; justifying your views.
Study smarter with the SolutionInn App