Question

In: Finance

Using your Excel TVM Calculators answer the following questions, be sure to submit your spreadsheet with...

Using your Excel TVM Calculators answer the following questions, be sure to submit your spreadsheet with your answers highlighted.

At what annual interest rate must $137,000 be invested so that it will grow to be $475,000 in 10 years?

If you wish to accumulate $175,000 in 13 years, how much must you deposit today in an account that pays an annual interest rate of 15%?

How many years will it take for $125,000 to grow to be $500,000 if it is invested in an account with an annual interest rate of 9%?

What will $137,000 grow to be in 12 years if it is invested today in an account with an annual interest rate of 10%?

If you wish to accumulate $200,000 in 7 years, how much must you deposit today in an account that pays a quoted annual interest rate of 12% with semi-annual compounding interest?

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.


Related Solutions

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have interest expense of $2,000,000 and 1,000,000 common shares outstanding, whereas the second would have interest expense of $3,800,000 but only 750,000 shares outstanding. The company is in the 35% tax bracket. Part 1: Construct the...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm had the following abbreviated income statement for 2020 and abbreviated balance sheets at the end of 2020 and 2021. 2020 Sales $600,000 Less Cost of goods sold 320,000 Gross Profit 280,000 Less Operating expenses 190,000 Less Depreciation 30,000 Operating Income (EBIT) 60,000 Less Interest expense 20,000 Earnings Before Taxes...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in the 35%...
Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each...
Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each question, and your Excel Solver solution; ensure that you clearly identify each answer. A local pastry shop is planning their next morning’s production. The shop has three main items that they sell: cakes, cupcakes, and cannolis. All of these are made in-house with the shop’s own ingredients. The recipes for these items are as follows: Cakes: 5 eggs, 2 cups flower, 15 g of...
chapter 14 Create an Excel spreadsheet to organize your answers to the following problem, and submit...
chapter 14 Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in...
Answer the following questions and submit answers in Microsoft Word. Be sure to fully answer each...
Answer the following questions and submit answers in Microsoft Word. Be sure to fully answer each question. 1. Does a precedent system operate in your social group, at work or in making your personal decisions? Explain. 2. Burglar Bob breaks into Vince Victim’s house. Bob steals a flat screen television and laptop and does a significant amount of damage to the property before he leaves. Fortunately, Vince has a state-of-the-art security system. It captures excellent images of Bob, who is...
You need to create an excel spreadsheet that answers the following questions. Where stated, make sure...
You need to create an excel spreadsheet that answers the following questions. Where stated, make sure you solve the problem “by hand”, i.e. discounting each cash flow, and also using TVM formulas from Excel. All work should be presented in three sheets/tabs (not files). Your sheets should be labeled. Questions 1-4 are in the first tab, questions 5-6 are in the second tab, and question 7 is in a third tab. In all cases, presentation matters!!! Make these professional. Also,...
*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit;...
*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit; no hard keys. Problem 2-1: Preparing Financial Statements Information below is for Warner Manufacturing, Inc. for the year ended December 31, 20x1 except where beginning of year numbers indicated. All amounts in SAR unless otherwise stated. Using the information below: 1. Prepare an income statement with the proper title 2. Prepare end of year balance sheet with the proper title 3. Calculate net working...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT