Solve through excel per year. How much will you have in 10 years? 2. Bernard needs $140,000
Fantastic news! We've Found the answer you've been seeking!
Question:
Solve through excel
Transcribed Image Text:
per year. How much will you have in 10 years? 2. Bernard needs $140,000 in 9 years for his daughter's education. If he can earn 7.5% per year, how much does he need to invest today? 3. You have $38,000 to invest and you need $70,000 for a down payment and closing costs on a house. If you want to buy the house in 8 years, what rate of interest do you need to earn? 4. You have $18,000 to invest right now and you figure you will need $25,000 to buy a new car. If you can earn 7% per year, how long before you can buy the car? 5. Consider the cash flows presented in the table below. What is the value of the cash flows in year 4 if the interest rate is 6 percent compounded annually? Year 1 2 3 Year 1 2 3 4 6. Consider the cash flows presented in the table below. What is the present value if the appropriate interest rate is 7 percent compounded annually? 4 5 Cash Flow 17,000 15,000 19,000 21,000 Cash Flow 21,000 14,000 21,000 13,000 18,000 7. What is the present value of $16,000 per year for 12 years if the interest rate is 7%? 8. You are going to borrow $600,000 to buy a house. What will your monthly payment be if the annual interest rate is 6.2 percent, and you borrow the money for 30 years? 9. You borrow $65, 000 to be repaid in 5 equal payments at the end of each of the next 5 years. The bank charges 6.3 percent compounded annually. Prepare the loan amortization schedule. per year. How much will you have in 10 years? 2. Bernard needs $140,000 in 9 years for his daughter's education. If he can earn 7.5% per year, how much does he need to invest today? 3. You have $38,000 to invest and you need $70,000 for a down payment and closing costs on a house. If you want to buy the house in 8 years, what rate of interest do you need to earn? 4. You have $18,000 to invest right now and you figure you will need $25,000 to buy a new car. If you can earn 7% per year, how long before you can buy the car? 5. Consider the cash flows presented in the table below. What is the value of the cash flows in year 4 if the interest rate is 6 percent compounded annually? Year 1 2 3 Year 1 2 3 4 6. Consider the cash flows presented in the table below. What is the present value if the appropriate interest rate is 7 percent compounded annually? 4 5 Cash Flow 17,000 15,000 19,000 21,000 Cash Flow 21,000 14,000 21,000 13,000 18,000 7. What is the present value of $16,000 per year for 12 years if the interest rate is 7%? 8. You are going to borrow $600,000 to buy a house. What will your monthly payment be if the annual interest rate is 6.2 percent, and you borrow the money for 30 years? 9. You borrow $65, 000 to be repaid in 5 equal payments at the end of each of the next 5 years. The bank charges 6.3 percent compounded annually. Prepare the loan amortization schedule.
Expert Answer:
Answer rating: 100% (QA)
1 If you invest 2000 per year at 5 interest per year you will have 24000 in 10 years 2 To have 14000... View the full answer
Related Book For
Thermodynamics An Interactive Approach
ISBN: 978-0130351173
1st edition
Authors: Subrata Bhattacharjee
Posted Date:
Students also viewed these finance questions
-
What are the values of the mean and the standard deviation in the standard normal distribution?
-
Read the following case and answer the questions that follow Employees involved in the accounting and control functions of organizations often face ethical dilemmas. Typically, at some point in each...
-
What are the values of effective capacitance which can be obtained by connecting four identical capacitors, each having a capacitance C?
-
The figure below represents a schematic of pipe network. A rate of 35 Ls, is pumped to feed two lines (3-4-5-6; and 2-7-8). The length and diameter of each pipe segment are listed in the table....
-
Refer to Exercise 4.71. One potential confounding variable was the amount of exercise the physicians got. The randomization should have balanced the treatment groups on exercise. The contingency...
-
Define slew rate and define full-power bandwidth.
-
Are there any cases you can find where a supplemental pleading was allowed because new facts have been alleged? What were the new facts?
-
Relevant costs, capital budgeting, strategic decision. (M. Porporato, adapted) Wilcox is a family-owned company that has been making microwaves for almost 20 years. The companys production line...
-
Assuming you are a stock investor looking for opportunities in global equity market. Here's the link to data onrisk premium at country level...
-
There are two parallel servers in a system. Customers arrive this system with a Poisson process with rate . The service rates of the two servers are 1 and 2, respectively. If the system is empty, a...
-
Our customer arrives tomorrow to make a purchase decision on a $1M aircraft. The customer's chief engineer dreamt up an idea for a flight data collection system for a Cessna 172. Business development...
-
Tim Donaghy, a referee for the NBA, entered a guilty plea to two federal felony charges in connection with his bets and tips on NBA games. The charges are conspiracy to engage in wire fraud and...
-
The governor's report cited three key reasons that such levels of cheating flourished in APS. The first was that the district set unrealistic test-score goals, or "targets." \({ }^{\text {" } 752}\)...
-
Under the leadership of CEO Don Blankenship, Massey went from a family-operated company to a corporation with 150 mines with revenues of \(\$ 2.6\) billion. That growth came in response to Mr....
-
Piper High School is in Piper, Kansas, a town located about 20 miles west of Kansas City, Missouri. Christine Pelton was a high school science teacher there. Ms. Pelton, age 26, had a degree in...
-
Diamond Foods, Inc., was once a cooperative among walnut growers, known as Diamond Walnuts. In 2005, it became a publicly traded corporation. The shareholders of the corporation included the farmers...
-
A rocket launches upwards, accelerating at 5 m/s. If Its initial velocity is 0 m/s, how high does the rocket reach after 10 seconds?
-
A 20-cm-square vertical plate is heated to a temperature of 30oC and submerged in glycerin at 10oC. Calculate the heat lost from both sides of the plate.
-
Air enters the compressor of an ideal air standard Brayton cycle at 100 kPa, 290 K, with a mass flow rate (m) of 6 kg/s. The compressor pressure ratio is 10. The turbine inlet temperature is 1500 K....
-
Coal from Kentucky has the following analysis on a dry basis, percent by mass. S: 0.8%; H2: 5.4%; C: 80.1%; O2: 9.5%; N2: 1.2%; Ash: 3%. This coal is burned with 40% excess air. Determine the. (a)...
-
Carbon monoxide at 20oC and 100 kPa enters a combustion chamber and burns with 25% excess air entering at the same temperature and pressure. An equilibrium mixture consists of CO2, CO, O2, and N2...
-
When a sphere of \(0.25 \mathrm{~mm}\) diameter and specific gravity 5.54 is dropped in water at \(25^{\circ} \mathrm{C}\) it will attain a constant velocity of \(0.07 \mathrm{~m} / \mathrm{s}\)....
-
A 1:50-scale model of a submarine is to be tested in a towing tank under two conditions: motion at the free surface and motion far below the surface. The tests are performed in freshwater. On the...
-
Your favorite professor likes mountain climbing, so there is always a possibility that the professor may fall into a crevasse in some glacier. If that happened today, and the professor was trapped in...
Study smarter with the SolutionInn App