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

The sanford company had the following balance sheet as of

The Sanford Company had the following balance sheet as of December 31, 20x2. The transactions for the first three months of 20x3 are also presented along with other information about specific accounts. Sanford Company Ba ...

Assignmenttravel-r-us inc travel is a publicly-traded

Assignment Travel-R-Us, Inc. (Travel) is a publicly-traded company with annual revenue of $370 million and a fiscal year ending May 31. Travel owns and operates three cruise ships serving Alaska, the Mediterranean, and t ...

Comprehensive problem 1morgan companys balance sheet at

Comprehensive Problem 1 Morgan Company's balance sheet at December 31, 2016, is presented below. Morgan Company Balance Sheet December 31, 2016 Cash $30,000 Accounts Payable $12,250 Inventory 3050 Interest Payable 300 Pr ...

Problemmaquoketa services was formed on may 1 2017the

Problem Maquoketa Services was formed on May 1, 2017. The following transactions took place during the first month. Transactions on May 1: 1. Jay BradFord invested $40,000 cash in the company, as its sole owner . 2. Hire ...

How much did you borrow for your house if your monthly

How much did you borrow for your house if your monthly mortgage payment for a 30 year mortgage at 6.65% APR is $1,600?? A $218,080 B $202,503 C $186,926 D $233,658 E $249,235 F $264,812 Shady Rack Inchas a bond outstandi ...

Selected t-accounts of moore company are given below for

Selected T-accounts of Moore Company are given below for the just completed year: Raw Materials Manufacturing Overhead ________________________________________ Bal. 1/1 29,800 ________________________________________ Cre ...

Intermediate management accounting1carpe diem co reported

Intermediate Management Accounting 1. Carpe Diem Co. reported the following variances for the period: Direct materials price variance $1,700 U Direct labour efficiency variance 23,600 U Fixed overhead volume variance 10, ...

1it has been suggested that it is not possible to determine

1. It has been suggested that it is not possible to determine the point at which financial accounting and managerial accounting diverge. What does that mean? Your response should be at least 200 words in length. For prob ...

1 if a bartender can somehow accumulate extra liquor and

1. If a bartender can somehow accumulate extra liquor, and does not register the extra drinks, which of these activities could be spotted by the analytical methods we studied? A. The bartender steals the extra liquor B. ...

Assignmentthis assignment has 2 parts 1000 10 word theory

Assignment This assignment has 2 parts, 1000 + 10% word theory interpretation essay and a response to a practical application of the theory. The assignment must be typed, use Arial font, 12, to avoid plagiarism, make sur ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro