Enjoy Upto 30% off on all Your Assignments ORDER NOW
+61480015851 whatsapp white icon +61480015851 info@myassignmentservices.com

Accounting and Finance - Estimated Value of Work Performed - Triangles Pty Ltd, - Review Writing Assignment Help

Download Solution Order New Solution

Highlights

Internal Code: C_AI_DBDJ_DH

Accounting And Finance Review Writing Assignment Help

Assignment Task: A group of University friends, including a surveyor, town planner and spatial  scientist are proposing to commence a new business, Triangles Pty Ltd, commencing trading in July 2019. The following assumptions have been made:
  • A cash based accounting system is used
  • The Estimated value of work ramps up over the first 4 months (25% the 1st month, 45% the 2nd month, 58% the 3rd month, 70% the 4th month),  and in the 5th month it becomes constant
  • Fixed costs are constant for each month regardless of how many days it contains
  • Variable costs are determined as 25% percentage of the value of work performed in that month
  • GST payments/refunds will be made to the ATO at the end of October, January, April and July (rather than on the normal 21st)
  • Calculations for GST payments are for the end of those months
  • 10% GST Input Tax credit is claimable on all fixed and variable costs
  • 10% GST is payable on all receipts for work performed
  • An initial amount of $20,000 for cash on hand is held
  • Invoices will be issued using the following model:
o 40% of invoices will be in the same month that the work was  performed o 30% will be issued in the month following when the work was   performed o 30% will be issued 2 months following when the work was  performed
  • Accounts will be paid using the following model:
o 50% of accounts due at the end of the month will be paid o 25% of accounts due at the end of the month will be paid by the  end of the following month University of Southern Queensland | SVY4309 Assignment 1 2019 5 o 20% of accounts due at the end of the month will be paid 2 months  later o 5% of accounts will never be paid Task 1. Using a spreadsheet program, prepare a table similar to Table 1, using the  provided assumptions. Indicate using cell colours which cells are constant values, and which cells are calculated. Task 2.
  1. Using these new Estimated Value of Work Performed projections, with all other assumptions remaining the same, what would the new Cash on Hand values be?
  2. Comment on how these values will affect the proposed business.
Task 3.
  1. Using Option 1 suggested by the accountant, what would the new Cash on Hand values be?
  2. Comment on what effect this has.
Task 4.
  1. Using Option 2 suggested by the accountant, what would the new Cash on Hand values be?
  2. Comment on what effect this has.
Task 5.
  1. Using Option 3 suggested by the accountant, what would the new Cash on Hand values be?
  2. Comment on what effect this has. 
  3. Comment on the proposed company’s break even point in terms of gross fees.
Task 6. You required to calculate the charge out rate for the survey party per hour. Ensure you provide a spreadsheet outlining any assumptions, calculations and justifications. Task 7. Create a Discounted Cash Flow (DCF) for 5 years and 10 years for each  option
  1. Using your results from (a), determine the NPV’s for both options 
  2. Prepare a Funded Rate of Return (FRR) assessment for the two projects
  3. What advice would you give the client regarding both options, with particular emphasis on feasibility, risk, profit and return, and cash flow/funding?
  4. Discuss and describe any warnings or qualifying statements you would place on your information and advice
This Accounting and Finance Assignment has been solved by our Accounting and Finance experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.

Find My Solution

© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.