what the Excel spreadsheet workings out (formulas) are? 

A B C D E F G Question # 1 2 3 1. 4 II. 5 III. 6 IV. Bought goods for $3,905 GST inclusive Sold goods for $22,726 GST inclusive Sold goods for $1,420 GST exclusive Bought goods for $6,390 GST exclusive. Task 1 (a) - GST Details Ex GST GST Including GST GST Coll GST Paid $ 3,550.00 $ 355.00 $ $ 20,660.00 $ 2,057.82 $ 3,905.00 22,726.00 $ $ 355.00 2,057.82 $ $ 1,420.00 $ 129.09 $ 1,420.00 $ 129.09 $ 6,390.00 $ 581.82 $ 6,390.00 $ 581.82 TOTALS 7 8 9 10 11 12 13 14 GST collected on sales Less GST paid on purchases Equals GST Payable to ATO Task 1 (b) - GST $2,186.91 $1,072.73 $1,114.18