Financial Statement Forecasting and Cash Budget

Anonymous
timer Asked: Dec 13th, 2018
account_balance_wallet $25

Question Description

For this assignment, you will construct a firm's projected pro forma and balance sheet. Download the Excel template below and complete the included problem.

Financial Statement Forecasting


For this assignment, you will construct a firm's monthly cash budget. Download the Excel template below and complete the included problem.

Cash Budget

Unformatted Attachment Preview

Cash Budget Sales for Blue Bill Corporation are projected as follows for the months of June through November: June July August September October November $200,000 200,000 200,000 300,000 500,000 200,000 Credit sales account for 70% of the monthy sales and are collected one month after the sale. Other receipts for October are $50,000. Variable disbursements are 60% of sales each month. Fixed disbursements are $10,000 each month. $80,000 should be included in August for taxes. The company is obligated to make a $400,000 debt repayment in November. Beginning cash in June is $50,000. Desired ending cash each month is $10,000. Complete the monthly cash budget for Blue Bill Corporation for June through November. Blue Bill Corporation Cash Budget June Sales Cash sales Collections Other Receipts Total cash receipts Variable disbursements Fixed disbursements Other disbursements Total cash disbursements Net change during the month Beginning cash Ending cash Required cash Excess cash to invest Cash borrowed Data Class: Public July August September hrough November: after the sale. ough November. October November Data Class: Public Cash Budget Sales for Blue Bill Corporation are projected as follows for the months of June through November: June July August September October November $200,000 200,000 200,000 300,000 500,000 200,000 Credit sales account for 70% of the monthy sales and are collected one month after the sale. Other receipts for October are $50,000. Variable disbursements are 60% of sales each month. Fixed disbursements are $10,000 each month. $80,000 should be included in August for taxes. The company is obligated to make a $400,000 debt repayment in November. Beginning cash in June is $50,000. Desired ending cash each month is $10,000. Complete the monthly cash budget for Blue Bill Corporation for June through November. Blue Bill Corporation Cash Budget June Sales Cash sales Collections Other Receipts Total cash receipts Variable disbursements Fixed disbursements Other disbursements Total cash disbursements Net change during the month Beginning cash Ending cash Required cash Excess cash to invest Cash borrowed Data Class: Public July August September hrough November: after the sale. ough November. October November Data Class: Public ...
Purchase answer to see full attachment

Tutor Answer

sumitkeshri92
School: Carnegie Mellon University

hey broth...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors