LINK FOR THE BOOK (you can also check the questions): https://b123im434-mp02-y-https-library-books24x7-com.proxy.lirn.net/toc.aspx

PLEASE check the ass attached before answering the questions so you know the business I have been working on.

Worksheet for Assignment 19: The balance sheet

Using the template link provided at the start of this chapter:

1. Construct a balance sheet for your business as it might look on the day before you start trading. This should be done now.
2. List and explain the assumptions underpinning your financial forecasts.
3. Construct a balance sheet at the end of years 1, 2 and 3 assuming you achieve the level of sales in your sales forecast. These should be done after you have completed the pro forma profit and loss account (Assignment 18) and pro forma cash-flow forecast (Assignment 17).

Using the format on the break-even analysis sheet (Table 20.1):

1. Construct a break-even analysis for year 1 of your business from the figures calculated in the last three chapters.
2. Estimate the effect of the following events on your break-even point for each year:
   1. a 10 per cent rise/fall in sales volume;
   2. a 10 per cent rise/fall in unit selling price;
   3. a 10 per cent rise/fall in variable costs per unit of sale, eg a meal;
   4. a 10 per cent rise/fall in fixed costs;
   5. a requirement for achieving your profit objective by year 1 – now what ‘volume’ of product must you sell to break even?
   6. Table 20.1 (PICTURE ATTACHED)
3. Look back to Assignment 8 on Pricing, and review your proposed selling price in the light of work/research carried out during this assignment.

WORKSHEET FOR ASSIGNMENT 21: ESTIMATING FINANCING REQUIREMENTS

Based on your financial projections, state how much cash you need to raise to set up your business, and how and when you propose to repay it. Use the questions below as the format for your worksheet:

1. Based on the maximum figure in your cash-flow forecast, how much money do you need and what do you need it for?
2. How does this compare with the sum that you and your partners or shareholders are putting in (ie level of gearing)?
   For example, if you already have £/$/€1,000 of assets and are looking for a loan of £/$/€5,000, the funds required are £/$/€6,000. If you have already invested £/$/€500 and plan to put in a further £/$/€2,500, then your gearing is:
   
3. Where do you expect to raise the funds you need to finance your business?
4. Prepare a schedule showing when you need these funds.
5. How and when will any borrowing be repaid? Do a list like this:
   Source of repayment  Amount £/$/€  Date
   Total £/$/€
6. What percentage of your venture would you be prepared to sell to raise the required funds?
7. What exit route(s) could be open to potential investors?
8. What security, if any, is available as collateral for any loan?
   Security  Value £/$/€
   Total £/$/€
9. Will you be receiving any grants or loans to help to finance your business (other than from the organization to which you are now applying)?
   Source  Date  Funds provided  Amount £/$/€
   Total £/$/€
10. What further private cash, if any, is available to invest in the business?
    Source  Date  Funds provided  Amount £/$/€
    Total £/$/€
11. What are the key risks that could adversely affect your projections? (These could include technical, financial and marketing risks.)
    Risk area  Financial impact on:
    Sales  Profits
12. What contingency plans do you have to either manage or minimize the consequences of these risks?
    Risk area  Plan  Effect

WORKSHEET FOR ASSIGNMENT 22: STRESS TESTING YOUR BUSINESS PROJECTIONS

1. List the key assumptions that underpin the projections for your business.
2. List five factors that could adversely affect your sales projections.
3. List five factors that could adversely affect your costs and expense projections.
4. Under which of these circumstances would you plans be unviable?
5. What could be done to mitigate these risks?