Compute the net working capital cash flow

Assignment Help Finance Basics
Reference no: EM131178292

A. Financial Statement Analysis

Instructions: Using the Industry ratios provided for the Boat Building Industry information, complete the Comparative and Common-size financial statements below.  Discuss your observations on the results.  Please refer to the Project Requirements for complete instructions.

B. Ratio Analysis

Instructions: Research the Boat Building Industry information, and then complete the ratio analysis below.  Discuss your observations on the results. Please refer to the Project Requirements for complete instructions.

C. Financial Cash Flow Analysis

Instructions: Complete the Financial Cash Flow analysis below using the data provided in the Case write-up.  Discuss your observations on the results. Please refer to the Project Requirements for complete instructions.

D. Financing Growth

"Instructions: Using the financial statements below:

1. Compute the Internal Growth rate and Sustainable Growth rate.

2. Discuss your results.

3. Enter the required information to compute the External Financing Needed (EFN) for the project expansion. Use the original estimated project cost. The projected growth rate and the tax rate are given in the case write-up.

4. Re-compute the affected financial ratios.  NOTE -Round EFN up to the nearest $100,000. Assume that all of the new financing will come from Debt. Additionally assume that the Debt will carry a 5.5% Interest payment and that the projected Interest Expense will increase proportionately.

5. Discuss your results.

Please refer to the Project Requirements for complete instructions."                                                    

E. Debt Financing

Instructions: Compute the total amount of Bond financing needed for the expansion project.  Bonds may only be issued in Face amounts of $1,000. The Coupon rate will be 5.5% and the Market rate is 4%. Round your solution to the nearest $100,000. Discuss your observations on the results.  Please refer to the Project Requirements for complete instructions.

a. How much total Bond financing is needed?

b. At what price will the bonds trade after the initial issue?

c. What are the company's total annual interest payments?

d. What is the total market value of the bonds?

e. Please discuss the implications of your calculations and why the market value and the actual proceeds from the bond issue are different.

F. Capital Structure

"Instructions:

1. Input the projected growth rate and actual project cost into the Input Parameters box.    Note the new level of EFN.

2. Using the new level of EFN, recompute the financial ratios assuming all of the EFN will come from Debt.  Round up to the nearest $100,000. 

Assume the Interest payments will be 5.5% of new debt. 

3. Discuss your results, and what other options for financing the company has. Please refer to the Project Requirements for additional data and complete instructions."                                                                        

G. Net Present Value                                                                    

"Instructions: 

1. Compute the Net Working Capital cash flow required by the new production line.

2. Compute the expected  Operating Cash Flow from the production line.

3. Using the above cash flow data, compute the NPV of the project cost using the final estimated cost.  You must decide if the company will finance the entire project through debt, or will issue the original amount of Bonds and offer equity financing for the remaiining financing needs.   Be sure to use the appropriate projected interest payments.

4. Discuss your decision and the results. 

Please refer to the Project Requirements for additional data and complete instructions."

Attachment:- Finance Project.rar

Reference no: EM131178292

Questions Cloud

Should ebay establish the distribution cente : Ebay is considering whether to establish a sale distribution center in China. Given the large Chinese consumer market, Eaby estimates that its net sales revenues will be 15 million yuans in the first year, 20 million yuans in the second year, and 35 ..
Create a table in word to insert your calculations : Striker Auto is looking into their car manufacturing costs at its Kansas City Plant. Create a table in Word to insert your calculations and submit the completed table for this module's assignment.
Expect the pacific oceanto : The CCD (Carbonate Composition Depth) is the water depth atwhich the rate of supply of calcium carbonates from the surface isequal to the rate of dissolution. Do you expect the Pacific Oceanto have a shallower or deeper CCD than the Atlantic Ocean..
How they would measure and adjust performance of business : Using these cost drivers, explain how they would measure, manage, and adjust the performance of the business against these drivers.
Compute the net working capital cash flow : Compute the Net Working Capital cash flow required by the new production line. Compute the expected  Operating Cash Flow from the production line
Activity based costing : East Coast Marine Ltd (ECM) manufactures parts for small marine craft.-  Over the past decade, ECM's management has met its goal of reducing its reliance on government contract work to 50 per cent of total sales.
How has social networking impacted e-commerce : Briefly summarize the nature of social networking. How has social networking impacted e-commerce? In what ways have small businesses used social networking to increase their exposure?
Describe an example of a specific cost function : Describe an example of a specific cost function, and its associated cost driver. In your description, discuss how changes in the cost driver will impact that cost function and what types of cost behaviors you would expect and why.
Several beneficiaries of irrevocable trust created : Al was one of several beneficiaries of an irrevocable trust created by his grandmother. Al was given the right to withdraw the greater of $5,000 or 5% of the trust corpus each year. Al withdrew $100,000 from the trust the day before he died. The valu..

Reviews

len1178292

8/23/2016 1:54:34 AM

I need help with this finance project in excel.

Write a Review

Finance Basics Questions & Answers

  What is the projected dividend for next year

a) What is the projected dividend for next year? b) What is the current value of the stock using the Constant Growth Model of the Dividend Discount Model?

  Mcgonigal''s meats, inc. currently pays no dividends

McGonigal's Meats, Inc. currently pays no dividends. The firm plans to begin paying dividends in 3 years (at the end of t3). The first dividend at that time will be $1 and dividends are expected to grow at 5% per annum thereafter.

  Calculate roe , eva, cash flows and provide a comparison

Calculate ROE , EVA, Cash Flows and provide a comparison

  What are the percentage returns

Suppose a stock had an initial price of $69.27 per share, paid a dividend of $4.5 per share during the year, and had an ending share price of $86.98. What are the percentage returns if you own 25 shares?

  What is the contribution margin per dvd player

The selling price will be $900 per unit (well under the normal selling price). However, the Lancer Audio brand name will be attached to the product. What will be the impact on company profit associated with this order?

  How offshore outsourcing integrates national economies

A short definition of globalization is "the growing liberalization of international trade and investment, and the resulting increase in the integration of national economies." Discuss how offshore outsourcing integrates national economies.

  Some companiesrsquo debt-equity targets are expressed not

some companiesrsquo debt-equity targets are expressed not as a debt ratio but as a target debt rating on a firmrsquos

  Member of the treasury department

Who are they? Based on the current term (upward-sloping) structure of interest, and current short-term and long-term interest rates, what would be your strategy as a member of the treasury department of any of these corporations? Why?

  Minimum price for the convertible bonds

Sportime Fitness Center, Inc., issued convertible bonds with a conversion price of $51. The bonds are available for immediate conversion. The current price of the company's common stock is $44 per share. The current market price of the convertible..

  Examples of entities with for-profit

Identify three specific examples of entities with for-profit, not-for-profit, and government financial environments in the health care industry. Compare the similarities and differences between the for-profit, not-for-profit, and government financ..

  Assume you are an analyst evaluating mesco company the

assume you are an analyst evaluating mesco company. the following data are available in your financial analysis unless

  Explain fully the reasons for your choice

Could this be balance sheet for St. Ann's Credit Union or Bank of America. Explain fully the reasons for your choice.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd