Prepare a spreadsheet to present a cash flow forecast

Assignment Help Financial Accounting
Reference no: EM131161402 , Length:

TASK 1 - Questions and Answers

1. You have a client who has not reported their company car expenses. They had forgotten to get a couple of receipts and decided not to worry about it. You are to write a statement for the client that outlines what types of expenses are allowable under taxation law and what receipts should be collected.

2. If you had a client who claimed an accelerated method of depreciation that resulted in a claim that was double the allowable amount ($90,000) what would the impact be and how would you explain this to the client?

3. Prepare a spreadsheet to present a cash flow forecast summary to a client for the forthcoming financial year. Make sure you include the company details and increasing cash balances. Include recomo nclations for the client in a statement.

4. What are two measures of budgetary control?

5. How can you control expenditure on wages, vehicles and telephone?

6. How should on accountant ensure they are clear in their recommendations?

7. Prepare a financial plan extract that summarises the scope of a client's objectives.

8. Summarise the following data for the following financial performance table.

Account 2014 2015 $ Difference Percent Common Size (per cent or sales income)





2014 2015
Income from $230,000 $320,000 $90,000 39 100 100
Costs from sales $115,000 $165,000 $50,000 43 50 51.6
Wage Costs $30,000 $45,000 $15,000 50 13 14
Transport Costs $25,000 $35,000 $10,000 40 10.9 10.9
Marketing Costs $15,000 $20,000 $5,000 33 6.5 6.3
Total costs $185,000 $265,000 $80,000 43 80.4 82.8
Profit $45,000 $55,000 $10,000 22 19.6 17.2

Task 2 - Financial and Business Performance Application

Your task is to research and discuss the following questions:

Where possible use practical examples and contextualize your answers to business practices for the
business you work in, a business you have access to or a simulated business. Where possible, participation in discussion with the client for clarification (your Assessor will fulfil this role where access to other is not possible.

1. In regards to taxation legislation how are business expenses treated?

2. what allowance is there for a business that manages on behalf of a trust?

3. Discuss the term "forecast returns" and what they are used for?

4. What is a not for profit organization and how do they abide by financial policies where they are required to prepare statutory returns?

5. What methods can you use to present a client's performance objectives?

6. Discuss the two methods of cash flow control?

7. When preparing a business's performance information what legislative acts do you need to consider?

8. If you needed information on financing who would you refer to?

Present your answers as an itemised report.

Task 3 - Case Study

Scenario

You have been asked to prepare the end of financial year reporting for BigFish Pty Ltd. Your task is to list each report that needs to be included for taxation purposes and a description of the contents of these reports. You should also outline each task you will be expected to perform. You should prepare a financial report and include it with your assessment using the following information:

968_Q3.jpg

Additional Information:
- Profit for the year ending 31 June 2014 was $88,448
- Profit for year ended 31 June 2015 was $94,000
- Cash received from customers totalled $330,000
- Cash paid for inventory totalled $170,000
- Cash paid for expenses totalled $20,000

- Dividends paid during the year were: $67,000
- During the year, accounts receivable decreased by $10,000
- Cost of new buildings acquired during the year $125,000
- No buildings were deposed of
- Land account was not affected by any transactions, but the fair market value of the land as of 31 June 2014 was $178,000
- Note that expenses included Entertainment Expense of 6,000
Bigfish management had the following aims for 2015:
- To reduce liabilities by 5%
- To increase profits by 8%
Were these goals met? Were they exceeded? Did they fall short? 1. Prepare a statement of Financial Position
- Include appropriate diagrams and graphs to highlight relevant information
- Ensure compliance with AASB standards (visit
https://www.aasb.gov.au/Pronouncements/Current-standards.aspx)
- It is advisable to have clear understanding of the standards before you start your assessment.
- Students with diverse background and academic status can obtain benefits by downloading and reading: Financial Instruments: Disclosures from the following website. https://www.aasb.gov.au/admin/file/content105/c9/AASB7_08-05_COMPdec13_01-14.pdf.

2. Prepare a statement of Financial Performance
- As above, include relevant diagrams and graphs and ensure compliance with relevant legislation and statutory compliance guidelines. Please confirm with your trainer if you are not clear about the statutory compliance.

Verified Expert

Reference no: EM131161402

Questions Cloud

Valuation truthfully is a weakly dominant strategy : Consider a second price sealed bid auction. Throughout our discussion, we have assumed that bidders are risk-neutral. Suppose that bidders are risk-averse. Does it change our conclusion that bidding one’s own valuation truthfully is a weakly dominant..
The amount of bending of the light into a material depend on : The amount of bending of the light into a material depends on the__-  The wavelength of red light is:- The material surrounding the core of the optical wave-guide is called:
What is the project''s npv : Your company is considering a new project. The required equipment has a 3-year tax life, after which it will have zero salvage value. What is the project's NPV
How the intervention could be implemented in a chosen area : Over time, the CDC began to recognize that centralizing the support for evidence-based interventions (EBIs) for HIV prevention could help slow the epidemic in the US. EBIs are programs that have been developed in research settings, tested in expe..
Prepare a spreadsheet to present a cash flow forecast : Prepare a spreadsheet to present a cash flow forecast summary to a client for the forthcoming financial year. Make sure you include the company details and increasing cash balances. Include recomo nclations for the client in a statement.
Techniques and tools that can be utilized to manage the data : Describe the techniques and tools that can be utilized to manage the data. Include at least 2 effective techniques and 3 effective tools
Determine the power dissipated by the circuit at resonance : Calculate the values of R and C for the circuit to have a resonant frequency of 200 kHz and a bandwidth of 16 kHz.
How much of your tuition is currently funded through loans : How much of your tuition is currently funded through loans? How much of your tuition is currently funded through personal savings or salary? List at least two ways you could change your educational financial plan in future years.
Techniques and tools for managing the data : Assignment: Discussion-Techniques and Tools for Managing the Data. What would be some of the mistakes or consequences of not investigating the costs associated with the organization's information systems (data collection) choice

Reviews

Write a Review

Financial Accounting Questions & Answers

  Define and describe the internal rate of control

Define and describe Net Present Value (NPV) as it pertains to the new cafe, define and describe the internal Rate of Control

  Required rate of return on the stock

A stock you are evaluating just paid an annual dividend of $3.40. Dividends have grown at a constant rate of 2.1 percent over the last 15 years and you expect this to continue. If the required rate of return on the stock is 16.5 percent, what should ..

  What is the company break even per in total sales

The president wanted to know the tweak even for each of the company's products. but tarn having trouble figuring them out.

  How do companies use responsibility centers

How do companies use responsibility centers? How are the managers of the responsibility centers held accountable? Why is budgeting important? Describe how you use budgeting in your personal life or in your company.

  How ordinary business functions will be conducted

XYZ Partnership consists of 10 general partners. As a general rule, what is the minimum number of these partners that would have to agree on how ordinary business functions will be conducted?

  Sale on its income statement for fiscal

On December 28, 2012 Piedmont Supply Co. ships $155,000 of merchandise by common carrier to the Maxwell Company. The terms of the sale are 3/15, n/45, FOB destination. It takes 5 days for the merchandise to arrive at Maxwell Company. Both Piedmont Su..

  What is the return on the given investment

What is the return on this investment? How would you decide whether this outlet should continue to be operated, sold as a going concern, or demolished and the land sold?

  Tax consequences on the eventual redemption

You should also tell her the PUC and ACB of the Class A preferred shares and the common shares that she has received and deal with the tax consequences on the eventual redemption of the 3,500 Class A preferred shares.

  Journalize the entry to record the payment of the payroll

Journalize the entry to record the payroll accrual and journalize the entry to record the payment of the payroll.

  What was the corporations net sales

What was the corporation's net sales, cost of goods sold, and gross profit?- What was the corporate tax rate?- What was the corporation's net interest expense?

  Explain how cost-volume-profit analysis

Review the Chapter opener. Johnny Cupcakes, launched by entrepreneur John Earle, produces t-shirts in unique styles and limited quantities. Selling prices typically range from $40 per shirt to $70 per shirt.  Identify at least two fixed costs that wi..

  Prepare journal entry for issuance of bonds

Evaluate the amount of accrued interest that was included in the proceeds received from the bond sale. Show calculation and prepare journal entry for issuance of the bonds.

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