Copy and Paste Your Assignment Here
LOAN PAYMENTS DATE:2/13/18 LOAN PAYMENTS LOAN AMOUNTINTEREST RATE %PERIODIC INTEREST RATE %LOAN TERM (MONTHS)MONTHLY LOAN REPAYMENT &"Myriad Pro,Regular"&8&K000000Created: &D&"Myriad Pro,Regular"&8&K000000 1&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings TERM DEPOSIT DATE:2/13/18 TERM DEPOSIT SIMPLE INTEREST INVESTMENT AMOUNTINTEREST RATETERM (YEARS)SIMPLE INTEREST EARNED COMPOUND INTEREST USING FORMULA INVESTMENT AMOUNTINTEREST RATE %PERIODIC INTEREST RATE %TERM (YEARS)TOTAL COMPOUND INTEREST EARNED WHEN COMPOUNDED QUARTERLY COMPOUND INTEREST MANUAL TABLE QUARTERSTARTING VALUECALCULATIONCOMPOUND INTEREST EARNEDTOTAL AMOUNT AT END OF QUARTER TOTAL AMOUNT OF COMPOUND INTEREST$0.00 &"Myriad Pro,Regular"&8&K000000Created: &D &"Myriad Pro,Regular"&8 &K0000002&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings PAYG WITHHOLDING DATE:2/13/18 PAYG WITHHOLDING YEARLY GROSS SALARYWEEKLY GROSS PAYWEEKLY TAX WITHHELDWEEKLY NET PAY &"Myriad Pro,Regular"&8&K000000Created: &D &"Myriad Pro,Regular"&8 &K0000003&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings MARK-UP DATE:2/13/18 MARK UP CLIENTCOST PRICEVALUE OF MARKUP (35% OF COST PRICE)SERVICE PRICE RB Holdings Armitage University Crowd Pleasers Batwing Beer Company All 4 Fit Total Garden Essentials &"Myriad Pro,Regular"&8&K000000Created: &D&"Myriad Pro,Regular"&8 &K0000004&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings DEPRECIATION DATE:2/13/18 DEPRECIATION YEARSTARTING BALANCEDEPRECIATION ACCUMMULATED DEPRECIATIONENDING BALANCE 1 2 3 4 5 &"Myriad Pro,Regular"&8&K000000Created; &D&"Myriad Pro,Regular"&8 &K0000005&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings CPI (CONSUMER PRICE INDEX DATE:2/13/18 CPI (CONSUMER PRICE INDEX) YEARMONTHLY RENT + GSTYEARLY RENT TOTAL + GST 1 2 (inc. 3.1% CPI) 3 (inc. 3.1% CPI) &"Myriad Pro,Regular"&8&K000000Created: &D&"Myriad Pro,Regular"&8 &K0000006&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings BREAKEVEN DATE:5/3/17 BREAKEVEN Variable Cost/Income Average charge per hour of service$123.84 Average cost per hour of service$74.23 Contribution Margin FIXED ANNUAL EXPENSESESTIMATED COST Rent$87,600.00 Telephone$11,000.00 Staff Wages$365,000.00 Superannuation$24,950.00 Printing and Stationary$20,090.00 TOTAL Number of hours of service needed to breakeven Imcome needed to breakeven &"Myriad Pro,Regular"&8&K000000Created 3/05/2017&"Myriad Pro,Regular"&8 &K0000007&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings GST (GOODS AND SERVICES TAX) DATE:2/13/18 GST (GOODS AND SERVICES TAX) TRANSACTIONVALUE EXCLUDING GSTGSTVALUE INCLUDING GST Total Services (Income)$375,750.00 Purchase of equipment$100,000.00 Telephone bill$6,742.70 Purchase of consumables$1,430.00 GST COLLECTEDGST PAIDGST LIABILITY &"Myriad Pro,Regular"&8&K000000Created 3/05/2017&"Myriad Pro,Regular"&8 &K0000008&"Myriad Pro,Regular"&8&K000000Plan2go App New Premises Costings