Complete the projected income statement for the quarter

Assignment Help Accounting Basics
Reference no: EM131471858

ASSIGNMENT - COMPLETION OF A WORKBOOK OF BUDGET SPREADSHEETS

Relationship of Assignment to Learning Outcomes

Demonstrate knowledge of generally accepted accounting practices.

Although these are projected statements, they are prepared on the same basis as historical statements. Some of the transactions will help you understand the impact of accounting policies such as depreciation and accrual accounting with the latter especially evident when comparing the Income Statement and Cash Flow Statement.

Apply management accounting techniques to planning and short term decision making.

As the scenario is set in the future, preparing the assignment should also help with understanding the planning process and the use of tools such as excel to model different scenarios and ascertain their impact on the profit, cash flow and resources of a business?

Completing the Assignment -

Entering Data

You will answer the assignment in the templates contained in the Excel file downloaded from Stream. As an Excel program will automatically mark your assignment, care must be taken in how you prepare your answer. If the following instructions are not followed, you may lose marks.

The data sheet is where you are given the input data. The other sheets contain the output of financial and numeric data. On the output sheets you should only use formulae as this creates a workbook which is truly flexible. (Refer to Budget Spreadsheet Completion below.)

It is important to realise that the program operates on named cells contained within the template. The names of these cells must not be altered or relocated. To avoid this DO NOT use the cut and paste function, or drag and drop cells from one location to another. It is also not advisable to insert or delete rows or columns. Copying, pasting, and deleting cell contents is acceptable.

Budget Spreadsheet Completion

Marks will be awarded for the functionality and flexibility of your spreadsheet. The aim of this assignment is to produce a workbook of spreadsheets in which any changes in financial and numeric data in the Data Sheet will result in an update of the whole workbook. Therefore you must link the output with the Data Sheet and you should not enter numbers directly into the output areas on the other worksheets.

To help you, certain cells have been shaded pink and other blue. Entries of numbers or names from the information given should be entered in pink cells. Entries of formulae should be made in blue cells. Not all blue or pink shaded cells require entries.

Required:

(i) On the Data Input Sheet, enter the given data which has not yet been entered.

(ii) On Sales, Purchases& NCA sheet, complete the revenue, cash collections, purchases, payment to suppliers and depreciation calculations for the quarter 1 October to 31 December 2017.

(iii) On the Cash Flow Sheet, complete the Projected Cash Flow from Operations for each of the three months October, November and December and the totals for the quarter 1 October to 31 December 2017. Note some cash flow row have been named, but you will need to enter the remaining cash flows yourself.

(iv) On the Income Statement Sheet, complete the Projected Income Statement for the quarter ended 31 December 2017. NB A month by month Income Statement is not required. Note that some expenses have been identified but you need to enter the remaining expenses yourself.

(v) Check the flexibility of your workbook by changing the selling price to $9 and then type the resulting Net Profit and ending Cash Balance in the boxes provided on the Income Statement Sheet (remember to change the selling price back to the original before submitting your assignment).

Attachment:- Assignment Files.rar

Reference no: EM131471858

Questions Cloud

Did automaster or carey own the car : After Automaster Motor Co. bought a Honda from a private owner, it sold the car to Carey's Auto Sales. A Carey's employee went to Automaster, delivered a check.
Find the maximum feasible amount of data : Find the maximum feasible amount of data that can flow through this network? Show your step-by-step solution and present a summary of your final solution
Difference between a sale or return : Kenneth Stevenson, a car dealer doing business as T & S Enterprises, asked Peter Pan Motors if it could find a certain kind of white BMW.
Job description listed the working conditions : The job description for the position listed the educational requirements which Mr. Felix claims to have met. The job description listed the working conditions.
Complete the projected income statement for the quarter : On the Income Statement Sheet, complete the Projected Income Statement for the quarter ended 31 December 2017
Did snider bear the risk of loss : Stephen Snider bought and paid for an "as is" used car from Berea Kar Co. Snider had trouble with the car and ceased using it a month later.
Describe the evolution and functions of computer hardware : IT DISCUSSIONS- Describe the evolution and functions of computer hardware, computer architecture, and system and application software.
Did ownership of the cars pass to by-pass customers : Vernon Crum was a merchant in the business of selling used cars to used car dealers. By means of a sight draft, J&T Auto Sales bought some cars for resale.
What policy controls would your team recommend : Human Factors and Cyber Policy- What policy controls would your team recommend to help manage each of the 4 cybersecurity issues?

Reviews

len1471858

4/24/2017 3:27:28 AM

Please read all instructions before starting the assignment. To complete the assignment you need access to a computer, and a spreadsheet package. The recommended spreadsheet software is Microsoft Excel and the template provided is an Excel one. By now you should be familiar with Excel (refer Course Guide Appendix 1). You should first study the relevant material in the text and make sure you understand the concepts covered. Individual feedback is included on all excel files in each marked cell and on the results sheet. Apart from that, there will be feedback in the form of suggested solutions and overall comments by the marker.

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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