Complete the cash budget worksheet

Assignment Help Financial Management

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

Reference no: EM131869592

Questions Cloud

Find a specific example of a team or brand : Dynamic pricing or surge pricing refers to the setting of prices for a good or service based on demand at the moment meaning that during times of high demand.

What is the product margin decision rule : What would make an organization choose a variable rate over a fixed rate loan?What is the "product margin decision rule"?

How representation and affirmation is an important aspect : How representation and affirmation is an important aspect of multicultural study and how it may develop our respect for erceptions and experiences of others.

Researching influences compensation strategies : From the e-Activity, determine how the law you researched influences compensation strategies for all companies directly affected by the law in your state.

Complete the cash budget worksheet : Based on the information available to you, complete the Cash Budget worksheet below.

What is the firm multifactor productivity : The Dulac Box plant produces wooden packing boxes to be used in the local sea food industry. Current operations allow the company to make 500 boxes per day.

Can brock use the business judgment rule as a defense : Suppose that Firm Body brought a lawsuit against Brock claiming that he had breached the duty of loyalty by not disclosing his interest in Sunglow.

Draft one sentence that explains the different viewpoint : Find a source that counters your statement (has a different viewpoint). Draft one sentence that explains the different viewpoint.

Draw a network diagram : Draw a network diagram representing the following information: the project starts with three activities, A, B, and C, which can be done concurrently.

User Account

All Pages