Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

Assignment overview

This assignment has a management accounting orientation. It draws on management accounting topics which include budgeting, sensitivity analysis, cost volume profit analysis and decision-making. Assignment is designed to develop student’s ability to develop a well-reasoned financial plan. The plan is to be written from 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 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 the 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 analysis, this is a one product merchandising or retail business.

Suppose the following cash receipts pattern: 40% collected in month of sale; 55% in month after sale; 5% bad debts.
Suppose 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 would result in a debt / equity ratio of 1.5.

Guidelines for your work.

SECTION A: WORD DOCUMENT

Your assignment is to be a maximum of fifteen pages (including coversheet) and presented as follows:

Part 1) Written Report to bank:

The first part of the assignment is to be a one page written report to the bank. This page must include a description of the nature of the planned business activity, as well as the visionary statement which indicates business owner’s longer-term aspirations for the firm and implications for capital expenditure. Include any extra assumptions made (beyond those specified in the assignment) and give an indication of the debt exposure.

Maximum length of part 1: one page

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:
• If sales volume increases / decreases 10% from that expected
• 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

SECTION B: EXCEL REPORTS

Prepare an Excel spreadsheet of the business’s financial plan (to enable verification of figures and formulae appearing in the Microsoft Word document)

SECTION C: GROUP REPORT

Complete a small summary outlining their contribution to the completed assignment. This summary is to be typewritten and is to be a maximum of 200 words.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92662

Have any Question? 


Related Questions in Accounting Basics

Compare all three balance sheets on the basic grounds of

Compare all three balance sheets on the basic grounds of accounts and differences. 1. HDFC 2. Infosys and 3. Tata Steel. Balance sheets - https://www.dropbox.com/s/0zf1xlialpx54vs/Balance%20Sheets.rar?dl=0.

Paperprepare an 11- to 15-page paper not including the

Paper Prepare an 11- to 15-page paper (not including the title and reference pages) that assesses a legal/ethical issue or situation relating to a current, previous, or potential future work environment. Use at least 10 ...

Review the form 10-k for the company selected for team

Review the Form 10-K for the company selected for team assignments Write a 1,050- to 1,400-word paper on the following: 1. Management's Report on Internal Control Over Financial Reporting 2. The Independent Registered Pu ...

Please read the following instructions carefully- this

Please read the following instructions carefully - This assessment is to be completed according to the instructions given by your assessor. - This assessment can be taken home. - If you are not sure about any aspect of t ...

Practice questionsexplain the importance of the assumptions

Practice questions: Explain the importance of the assumptions used by accountants. and describe any four.

During the year mr ashok sold his private car for 50000 and

During the year mr. ashok sold his private car for 50000 and this amount invested in business he withdraw from business 1500 per month up to july 31st 2011 and thereafter 4500 per month as Drawing you are required to pre ...

Accounting information systems - team based

Accounting Information Systems - Team Based Assignment "Response to Request - For - Proposal (RFP) for an ERP System" Aim: This team based assignment is designed to give you the opportunity to learn about ERP systems and ...

Question 1you own an automobile parts company and have been

Question #1 You own an automobile parts company and have been approached by a leading car manufacturer to supply parts to the company. How would you determine that the car manufacturer has a good record of servicing sale ...

Practice questionswhat problems might arise in recording

Practice questions: What problems might arise in recording direct labour costs and how would you attempt to remedy them?

Taskin april 2016 the fair work ombusman released a report

Task In April 2016, the Fair Work Ombusman released a report on the findings of this inquiry on the 7 Eleven franchise network. The inquiry was prompted by allegations of systemic non-compliance with federal workplace la ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate