Step I: Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be approximately 60% of sales. You anticipate about 20% of your sales will be cash and 80% collected the following month. Your supplier has agreed to extend credit for 70 days at no cost (i.e. you will pay your bills on a two month lag). Your monthly expenses for rent, wages, utilities, and so forth will be approximately $3,500 per month. You have deposited $15,000 in a checking account to begin your operations and would like to maintain a minimum balance of $5,000 in that account.

Step II: Create a simple monthly cash budget. Create a spreadsheet file that contains a simple monthly cash budget for the next year for the business described in the above scenario.

Step III: Answer questions.

-Explain the purpose of creating budgets.

-Will you need additional funds at some point? Justify your answer

Alpha Geek

(8)

Status NEW Posted 28 May 2017 07:05 AM My Price 9.00

P-----------lea-----------se -----------fin-----------d a-----------tta-----------che-----------d a----------- PD-----------F f-----------ile----------- wi-----------th -----------nam-----------e M-----------ont-----------hly----------- bu-----------dge-----------t f-----------or -----------ref-----------ere-----------nce-----------. I-----------t c-----------ont-----------ain-----------s m-----------ont-----------hly----------- Ca-----------sh -----------Bud-----------get----------- as----------- re-----------qui-----------red----------- in----------- st-----------ep -----------II.----------- Th-----------e a-----------nsw-----------er -----------for----------- qu-----------est-----------ion-----------s

Attachments

1495957744-1515831_1_636314877946456240_monthly-budget.pdf

Not Rated(0)

• Buy Answer