What happens to afn and fcf

Assignment Help Accounting Basics
Reference no: EM131524705

Question: Start with the partial model in the file IFM9 Ch09 P10 Build a Model.xls from the ThomsonNOW Web site. Cumberland Industries' financial planners must forecast the company's financial results for the coming year. The forecast will be based on the percent of sales method, and any additional funds needed will be obtained by using a mix of notes payable, long-term debt, and common stock. No preferred stock will be issued. Data for the problem, including Cumberland Industries' balance sheet and income statement, can be found in the spreadsheet problem for Chapter 7. Use these data to answer the following questions.

a. Cumberland Industries has had the following sales since 2001. Assuming the historical trend continues, what will sales be in 2007?

1673_Sales.png

Base your forecast on a spreadsheet regression analysis of the 2001-2006 sales. By what percentage are sales predicted to increase in 2007 over 2006? Is the sales growth rate increasing or decreasing?

b. Cumberland's management believes that the firm will actually experience a 20 percent increase in sales during 2007. Construct the 2007 pro forma financial statements. Cumberland will not issue any new stock or long-term bonds. Assume Cumberland will carry forward its current amounts of shortterm investments and notes payable, prior to calculating AFN. Assume that any additional funds needed (AFN) will be raised as notes payable (if AFN is negative, Cumberland will purchase additional short-term investments). Use an interest rate of 9 percent for short-term debt (and for the interest income on short-term investments) and a rate of 11 percent for long-term debt. No interest is earned on cash. Use the beginning of year debt balances to calculate net interest expense. Assume dividends grow at an 8 percent rate.

c. Now create a graph that shows the sensitivity of AFN to the sales growth rate. To make this graph, compare the AFN at sales growth rates of 5, 10, 15, 20, 25, and 30 percent.

d. Calculate net operating working capital (NOWC), total operating capital, NOPAT, and operating cash flow (OCF) for 2006 and 2007. Also, calculate the free cash flow (FCF) for 2007.

e. Suppose Cumberland can reduce its inventory to sales ratio to 5 percent and its cost to sales ratio to 83 percent. What happens to AFN and FCF?

Reference no: EM131524705

Questions Cloud

Estimate the stock systematic risk from the market model : You must use at least 50 weekly or monthly observations on both stock and market returns to estimate the stock's systematic risk (beta) from the market model
Define the weighted average cost of capital : Cost of preferred stock, rps; cost of common equity or cost of common stock, rs.
Five-step marketing research process : You have decided to implement the Five-Step Marketing Research Process to help understand the problem and create solution strategies to implement.
Create one alternate hypothesis : Briefly describe your area of research interest. Create one alternate hypothesis and its associated null hypothesis related to your research area.
What happens to afn and fcf : Start with the partial model in the file IFM9 Ch09 P10 Build a Model.xls from the ThomsonNOW Web site. Cumberland Industries' financial planners must forecast.
What kinds of fallacies did you or they use : Describe the disagreement or argument. What kinds of fallacies did you or they use as part of the argument? Was it persuasive?
Calculate the percentage change in average speed : Calculate the percentage change in average speed during Spring Break relative to Christmas Break.
What is booth additional funds needed for the coming year : The Booth Company's sales are forecasted to increase from $1,000 in 2006 to $2,000 in 2007. Here is the December 31, 2006, balance sheet.
Quadratic formula on the exam : For the following quadratic function, find the largest X-intercept (largest value of X where Y is zero) using the Quadratic Formula.

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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