Read through the scenarios below and make a spreadsheet that accounts for the business' cash on hand.
Question:
Read through the scenarios below and make a spreadsheet that accounts for the business' cash on hand. Your spreadsheet should be neat & organized, and account for both gross and net income at the end of the week, month, and quarter. Date, transaction, & amountshould be clearly stated, along with Formulas that show gross & net income for the week, month, & quarter. Feel free to work with a partner.
Scenario: You own a small but growing lawn mowing & landscaping business. You are to track your cash flow from the first quarter of thisyear (2021). Assume all below transactions are made in cash.
Customers A-J get full service every Friday for $25/service
Customers K-P get mow only service twice/month for $30/service on the 2nd & last saturday of each month.
You pay your two employees $200 on the 1st & 15th of each month.
You pay yourself 15% of your net earnings on the last day of each month
On January 25th, you take on a landscaping job for customer Q.You charge the customer $500 for the job, and agree to accepthalf up front and the other half upon completion of the job.
On February 3rd, you take on customer R; another full service $25/week client beginning that week
On February 5th, customers B, C, & D didn't have the cash on hand to pay for services but agreed to pay double the next time
On February 9th you finish the job for customer Q.
On February 13th, you take on customers S-V for $30 twice/month services
On March 1st, you agreed to give employee #1 an advance on his next pay
Each Sunday, you spend $20 filling up your equipment with gas
On March 8th, customers F&N decide they want to discontinued services effective immediately
On March 10th, you bought a new trimmer for $75
On March 23rd, you took on and completed a landscaping projectfor customer W for $300