Question
Using the attached spreadsheet, calculate the cash balance at the beginning of March for Angel Food truck based on the information provided below. MonthSales RevenueJan280,000Feb300,000Mar240,000Apr195,000
Using the attached spreadsheet, calculate the cash balance at the beginning of March for Angel Food truck based on the information provided below.
MonthSales RevenueJan280,000Feb300,000Mar240,000Apr195,000
All sales are on credit; 70 percent is collected during the month of sale, and 30 percent is collected during the next month. Cost of good s sold is 80 percent of sales. Payments for goods purchased is made in the next month (30 day credit). Operating expenses total $56,000 per month and are paid during the month incurred . The cash balance on February 1 is estimated to be $25,000. In the space provided below, enter the budgeted cash balance as of beginning of March.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started