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

  What was the average issue price per share of preferred

what was the average issue price per share of preferred stock?7 preferred stock 100 par callable at 105. 50000 shares

  Determine the net credit and collection expense in dollars

Determine the net credit and collection expense in dollars and as a percentage of sales after considering the revenue not earned from other investment opportunities.

  Compute tax payable and wages that will be paid to employee

Compute the taxes payable and wages that will be paid to employees. Then prepare the journal entries to record the wages earned and the payroll taxes.

  Compute the total assets for this bank

Compute the banks total deposits and enter -compute the total assets for this bank and enter this figure on the left side of the balance sheet.

  Describe the advantages of a sole proprietorship

Describe the advantages of a sole proprietorship and a limited liability corporation and do you recommend that this client choose an LLC or not?

  Prohibition of the use of blockage factors

Does the FAS 157 prohibition of the use of blockage factors when measuring the fair value of a financial instrument that trades in an active market (i.e., Level 1 inputs) also apply to Level 2 and Level 3 inputs?

  The effects of operating leverage

Compare your answer in requirement H with your answer in requirement D. What conclusions can you draw about the effects of operating leverage from the steps you performed in requirements F, G, and H?

  Write a report and answer following questions

Write a two page report along with the solution. -  Review the Consolidated Statements of Earnings and Comprehensive Income for 2012 and 2011. What was the income tax expense for each year?

  Amount needed to be invested today to return monthly payment

How much would $10,000 invested annually at 8% provide you after 20 years? How much would $5,000 invested quarterly at 6% yield after 10 years? The amount necessary to be invested annually to reach a goal of $10,000 in 5 years assuming a 5% return? T..

  Depreciation for the manufacturing plant

AP constructed a new manufacturing plant for a total cost of $7,615,000 and placed it in service on March 2. To finance the construction, AP took out a $6 million, 30-year mortgage on the property. Compute AP’s MACRS depreciation for the manufacturin..

  Multiple choice questions related to price raise by

multiple choice questions related to price raise by supplier and the debit and credit.1 lunds balloon company has 2500

  What amount be recorded as goodwill by burrough corporation

Burrough also paid $3,000 to a search firm for finder's feesrelated to the acquisition. What amount will be recorded as goodwill by BurroughCorporation while recording its investment in Helyar?

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