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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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