Question

Iowa Diagnostic Center's projected Patient Revenues for the first six months of 2013 are given below:...

Iowa Diagnostic Center's projected Patient Revenues for the first six months of 2013 are given below:
Jan. $200,000 April $400,000
Feb. $240,000 May $320,000
Mar. $280,000 June $320,000
25% of patient revenues are collected in cash at time service is provided, 50% are collected in the month following provision of service, and the remaining 25% are collected in the second month following provision of the service. Payroll expenses are 75% of that month's revenues. Total other estimated expenses are $60,000/month. The company's cash balance as of February 28, 2013 will be $40,000. Excess cash will be used to retire short term borrowing (if any). Iowa Diagnostic will have no short term borrowing as of February 28, 2013. Assume that the interest rate on short term borrowing is 1% per month. The company must have a minimum cash balance of $25,000 at the beginning of each month. Round all answers to the nearest $100

Based on the information in Table 5-1, what will be Iowa Diagnostic Center's ending cash balance (before borrowing) in March? (Do not include commas in answer)

Homework Answers

Answer #1

Calculation of ending cash balance:

Beginning Cash Balance = $40,000

Add: Cash Receipts

Cash Sales 25%*280,000 =$70,000

50% of feb collected in March = 50%*240,000 =$120,000

25% of Jan collected in March = 25%*200,000 =$50,000

Total Cash Available =$280,000

Less: Cash Payments

Payroll Expenses =75%*280,000 = $210,000

Other estimated expenses =$60,000

Total Payments=$270,000

Ending cash balance of March before borrowings =$10,000

HENCE, the answer is $10,000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Jingga Big Supplies’ projected sales for the next six months of 2020 are given below. July...
Jingga Big Supplies’ projected sales for the next six months of 2020 are given below. July                             RM500,000     October           RM800,000 August                         RM600,000     November       RM900,000 September                  RM800,000     December       RM800,000 40% of sales is collected in the month of the sale, 50% is collected in the month following the sale, and 10% is written off as uncollectible. Cost of goods sold is 70% of sales. Purchases are made on the month prior to the...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months of 2016 as​ follows: January ​$120,000 April ​$280,000 July ​$200,000 February   140,000 May   275,000 August   200,000 March   170,000 June   200,000 ​(Click on the icon located on the​ top-right corner of the data table above in order to copy its contents into a spreadsheet.​) PrintDone . Lewis collects 30 percent of its sales in the month of the​ sale, 50 percent in the month following...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. 10% of all sales are for Cash. Credit customers usually pay 20% of their fee in the month that service is provided, 60% the month after, 18% the second month after receiving service. The remaining 2% is written off...
Maleficent Company Limited is preparing budget based on the information below. 1. Budget sales revenues: January...
Maleficent Company Limited is preparing budget based on the information below. 1. Budget sales revenues: January February March $ $ $ Credit sales 550,000 450,000 650,000 Cash sales 65,000 55,000 55,000 Total sales 615,000 505,000 705,000 Past experience indicates that customers usually settle their balances as follows: - 60% of a month's credit sales are collected in the month of sale; and - the remaining 40% of a month's credit sales are collected in the following month. All purchases are...
V had actual sales and purchases for July and August 2020 as given in the Excel...
V had actual sales and purchases for July and August 2020 as given in the Excel spreadsheet, along with its forecast sales and purchases for the period September 2020 through February 2021. The firm makes 30% of all sales for cash and collects 35% of its sales in each of the two months following the sale. Other cash inflows are expected to be $22,000 in September and February, $25,000 in November and January, and $37,000 in December. The firm pays...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially...
The information given below is Bobcats Company’s beginning balance sheet, estimates and policies, and the partially completed Master Budget for January and February. Use the information to answer the 22 Multiple Choice Questions, each asking for a missing number from the Master Budget. Round all your computations to the nearest dollar. Sales are expected to be $80,900 in January, $100,900 in February, and $105,900 in March. All sales are on credit and it collects 20% of all sales in the...
Given the following info, I created a trial balance (also shown below): Karen Noonan opened Kingbird...
Given the following info, I created a trial balance (also shown below): Karen Noonan opened Kingbird Inc. on February 1, 2017. During February, the following transactions were completed: Feb. 1 Issued 4,400 shares of Kingbird common stock for $13,260. Each share has a $1.50 par. 1 Borrowed $8,000 on a 2-year, 6% note payable. 1 Paid $9,200 to purchase used floor and window cleaning equipment from a company going out of business ($4,440 was for the floor equipment and $4,760...
Determine the below ratios for 2011 and 2012 and compare the Hospitals financial performance year to...
Determine the below ratios for 2011 and 2012 and compare the Hospitals financial performance year to year based on those ratios. Make sure you explain what each ratio measures Return on Net Assets Cash Flow to Debt FINANCIAL STATEMENTS: Cash Flows from Operating Activities:                         2012                    2011 Cash received from patient services                             $3783                 $2590 Cash paid to employees and suppliers                         (3684)                (2541) Interest paid                                                                           (16)                       (14) Interest earned                                                                        13                            6 Net Cash from Operations                                                     $96                      $41 Cash Flows from Investing Activities:...
  1.     In the first month of operations, the total of the debit entries to the cash...
  1.     In the first month of operations, the total of the debit entries to the cash account amounted to $1900 and the total of the credit entries to the cash account amounted to $800. The cash account has a balance of……………….     2.     Dawson’s Delivery Service purchased equipment for $3,500. Dawson paid $500 in cash and signed a note for the balance. Dawson debited the Equipment account, credited Cash and a.   debited the Dawson, Capital account for $2,000. b.   credited...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the right side. Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. (Hint) Excel provides functions for...