Reference no: EM131869592
Purchase Budget,Cash Budget,Budgeted Income Statement,and Budgeted balance Sheet are given with the attachments.review the data and complete them.
There are 4 tabs- A, B, C, and D. I have completed tab A. Please help me complete Tabs B, C, and D.
Part 1
Based on the information available to you, complete the Cash Budget worksheet below:
Check figures are: January Cash Receipts = $211,200; February Cash Disbursements = $194,414; March Ending Cash Balance = $165,519.
Part 2
Based on the information available to you, complete the Budgeted Income Statement worksheet below:
Check figures are: January Budgeted Gross Margin = $88,000; February Budgeted Operating Income = $25,920; March Budgeted Net Income = $14,247.
Part 3
Based on the information available to you, complete the Budgeted Balance Sheet worksheet below:
Check figures are: January Total Assets = $535,399; February Total Liabilities = $267,971; March Total Current Assets = $337,229.
Attachment:- Budget-assignment-worksheet.rar