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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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