Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Assignment 2: Creation of a Financial Plan 
Assignment overview This assignment has a management accounting orientation. It draws on management accounting topics that include budgeting, sensitivity analysis, cost volume profit analysis and decision-making. The assignment is designed to develop the student's ability to develop a well-reasoned financial plan. The plan is to be written from the perspective of a small start-up business that is seeking to document its worthiness to a bank in order to secure a loan. Students have the choice of working on their own, or in teams of up to four people. 

Assignment details 
You have approached a bank and asked for a loan in connection with a small business you are planning to start. The bank has requested that you prepare a detailed financial plan in support of your loan application 

Assumptions/Criteria 

  • To simplify the analysis, this is a one product merchandising or retail business.
    Assume the following cash receipts pattern: 40% collected in month of sale; 55% in month after sale; 5% bad debts.
    Assume the following cash payments pattern for inventory purchases: 30% paid in month following the purchase, 70% paid two months after the purchase.
    Ignore GST and any other taxes.
    The loan you seek will result in a debt / equity ratio of 1.5.
    Part 2) A one year plan (individual budgets can be broken up by month or quarter) which includes:

    One page dedicated to each of the following:
    - Data Input sheet
    - Sales budget
    - Inventory purchases budget
    - Other operational budgets
    - Budgeted Income statement in contribution format
    - Cash flow budget
    - Budgeted Balance Sheet
    - Capital expenditure budget
    - Sensitivity analysis of profit and cash flows:
    a. If sales volume increases / decreases 10% from that expected
    b. If variable costs increase by 20%

    Total length of part 2: nine pages

    Part 3) A long term plan (5 years) which includes:

    One page dedicated to each of the following:
    - Sensitivity analysis of income statement (in contribution format)
    - Sensitivity analysis of cash flow budget
    - Capital expenditure plan.

    Sensitivity analysis is to document profitability and cash flow under three sales volume scenarios: best case, most likely, and worst case scenarios.

    Total length of part 3: three pages

    Part 4) Cost volume profit assessment

    One page dedicated to:
    Breakeven analysis and margin of safety analysis (in units and sales dollars). The margin of safety analysis should assess three sales volume scenarios: best case, most likely, and worst case scenarios.

    Total length of part 4: one page

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M9419293

Have any Question?


Related Questions in Basic Finance

Calculate the value of a bonds with face value of 1000 a

Calculate the value of a bonds with face value of $1,000 a coupon interest rate of 8 percent paid semiannually; and a maturity of 10 years. Assume the following discount rate (a) 6 percent (b) 8 percent (c) 10 percent

How can businesses use technology and relationships to

How can businesses use technology and relationships to reduce their environmental impact?

Financial statement analysis for comcastprepare an eight-

Financial Statement Analysis for Comcast Prepare an eight- to ten-page fundamental financial analysis (excluding appendices, title page, abstract, and references page) that will cover each of the following broad areas ba ...

The free cash flows in millions shown below are forecast by

The free cash flows (in millions) shown below are forecast by Bailey Brothers. If the weighted average cost of capital is 11%, and FCF is expected to grow at a constant rate of 5% after Year 3 (i.e., Year 4 to infinity) ...

In 1896 the first us open golfnbspchampionship was held the

In 1896, the first U.S. Open Golf Championship was held. The winner's prize money was $160. In 2012, the winner's check was $1,360,000. Requirement 1: What was the annual percentage increase in the winner's check over th ...

Question - assume that you are given a one year forward

Question - Assume that you are given a one year forward price of $ 50 and domestic rate interest of 6% per annum. Determine what the spot price using continues time.

Tiffany borrows a 200000 5 years loan at 7 with a fixed

Tiffany borrows a $200,000, 5 years loan at 7%, with a fixed amount of principal to be repaid every year. What is the total amount that she will need to pay at the end of year 4? (round off all answers to 2 decimal place ...

Market-value ratios garret industries has a priceearnings

(?Market-value ratios?) Garret Industries has a? price/earnings ratio of 19.46X a. If? Garret's earnings per share is ?$1.65?, what is the price per share of? Garret's stock? b. Using the price per share you found in par ...

Question - robert gillman an equity research analyst at

Question - Robert gillman, an equity research analyst at Gillman Advisors, believes in efficient markets, He has been following the mining industry for the past 10 years and needs to determine the constant-growth rate th ...

In what way does service firms and manufacturing

In what way does service firms and manufacturing corporations compare in accounting for direct materials?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As