Prepare cash flow forecast and conduct sensitivity analysis

Assignment Help Financial Accounting
Reference no: EM13332736

Part -1:

Case study: BUTTERFLIES

1. Prepare a cash flow forecast. Assume that the business will be run for 6 years, and then the building will be sold for 300,000. The equipment will be depreciated straight line over the life of the restaurant. The tax rate is 30%.

2. If the required return of the investors is 14% should the expansion proceed?

3. Conduct a sensitivity analysis which explores the impact on the viability of the project of:

a. The level of sales
b. The cost of food as a percentage of sales and
c. Working capital as a percentage of sales

4. Write a report to Lisa and Mark which uses your answers to 1, 2 and 3 as the basis for a recommendation on the investment.

Part -2:

Please "run the numbers" for Mark and Lisa.

1. Prepare a cash flow forecast for the appropriate period. Assume that the restaurant will be run for six years, at the end of which the building could be sold for £300,000 but the equipment will have no value at all. Also assume that tax will be calculated at 30% of profits ignoring depreciation, and that there are no tax allowances available on any of the equipment. Tax is paid in the year after the profit is made.

2. Note that Mark and Lisa require a return of at least 14%. Should they go ahead with the Oakley expansion?

Reference no: EM13332736

Questions Cloud

Fluctuations in the level of economic activity : Economic fluctuations (or business cycles) are fluctuations in the level of economic activity, relative to a long-term growth trend. Can I get some help comparing and contasting the economic fluctuation of the U.S. from 1990 to present with reference..
Implement some very sophisticated server-side scripting : Discuss this in relation to server security, the continuing trend to eCommerce and the continual rise in popularity of PHP as a solution to eCommerce applications.
Find average force does the punter exert on the ball : A football punter accelerates a football from rest to a speed of 9 m/s during the time in which his toe is in contact with the ball, what average force does the punter exert on the ball
Determine how many cups of coffee do have to sell roi : You are open 7 day per week 2. Raising or lowering the price has not effect on sales 3. Price of coffe, sugar, etc. and cups are included in the 20,000K price Questions: How long will it take to break even
Prepare cash flow forecast and conduct sensitivity analysis : Prepare a cash flow forecast. Assume that the business will be run for 6 years, and then the building will be sold for 300,000. The equipment will be depreciated straight line over the life of the restaurant.
Difference between a personality and an artist : Playwrights, designers, and directors are often called "artists" of one sort or another; yet in the U.S actors are often considered "personalities" rather than artists. What is the difference between a personality and an artist when it comes to actin..
Find initial momentum of the system : A car of mass 150 kg is moving right with a velocity of 6 m/s and another one of mass 200 kg is moving left with a velocity of 4 m/s. find initial momentum of the system
What is the probability that alicia filled the order : Alex, Alicia and Juan fill orders in a fast-food restaurant. Alex incorrectly fills 20% of the orders he takes. Alicia incorrectly fills 12% of the orders she takes. Juan incorrectly fills 5% of the orders he takes.
Determine what is the current value of the lease : Payments are due on the first day of each month starting with the day you sign the lease contract. If your cost of money is 4.9 percent, what is the current value of the lease

Reviews

Write a Review

Financial Accounting Questions & Answers

  Estimated total future cash flows

At the beginning of 2013, based on new marketing research, Barkley determines that the fair value of the trade name is $24,000. Estimated total future cash flows from the trade name are $26,000 on January 4, 2013.

  Elucidate how recording the share issue costs differs

Prepare the journal entry to record the issuance of the shares. Elucidate how recording the share issue costs differs from the way debt issue costs are recorded.

  Illustrate what is the difference between these two waccs

The CFO thinks the WACC should be based on market value weights, but the president thinks book weights are more appropriate. Illustrate what is the difference between these two WACCs?

  Effect on the contribution margin per unit

Effect on the contribution margin per unit and the contribution margin ratio and calculation used in a CVP analysis is the breakeven point.

  Determine the earnings per share on common stock

Determine the earnings per share on common stock, assuming income before bond interest and income tax is $2,000,000 and enter answers in dollars and cents, rounding to the nearest whole cent.

  Examine long-term borrowings in british airways balance

Examine long-term borrowings in British Airways's balance sheet and the related note. What, if any, convertible securities does the company have outstanding?

  Who in turn would do the same until several checks

Money from these accounts could be mixed or further divided and sent to other accounts or individuals, who, in turn, would do the same, until several checks for $1000 or less eventually arrive at party headquarters.

  Calculate receivables turnover ratio and average collection

Calculate the receivables turnover ratio and the average collection period for 2007 for FedEx. (Round to 3 decimal places, e.g. 2.555.)

  Explain how were these obligations violated in hp case

The original lawsuit filed in the HP case claimed that the executives breached their fiduciary responsibilities. What are the fiduciary responsibilities of executives and members of the board of directors to shareholder? Explain how were these obl..

  Find out the price of the bonds

he market rate of interest 12%. The interest is paid on June 30 and December 31. Find out the price of the bonds at January 1, 2010. Prepare the journal entry to record the issuance by Carla Industries on Jan 1, 2010

  Need of cash to be maintained

Calculation of requirement of cash to be maintained and The Wallace Company must maintain a minimum cash balance of $30,000. At the beginning of February the company's cash balance was $50,000.

  Net income per books of adamson company

The net income per books of Adamson Company was determined without knowledge of the errors indicated below. Prepare a work sheet to show the adjusted net income figure for each of the 6 years after taking into account the inventoryerrors.

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