1.If we look at the Balance Sheet for April, we see that Medieval Adventures Company goes into negative cash on this month. July is the last month of negative cash flow. Cash bottoms out at $(40,000), so this is the amount of funds they will need to raise. If they decide to get a short-term loan for the $40,000, they will be able to repay it in October. A line of credit may be better suited for this situation. They can draw the money as needed and only pay interest on the portion drawn upon. 2.Even though they were profitable in a very short period of time, monthly increases in account receivable ($55,000/month) and inventory ($17,500/month) were burning through cash faster than they were able to recover it from customers. All this could have been avoided if they created a yearly Profit Plan at the beginning of the year. Part of the plan would have been a cash budget which would show them that the way they had things setup would leave them without cash by April. With the information from the cash budget they could have done a few things. a.They could have setup a line of credit if they wanted to keep things as they were. b.They could setup sales discounts if their invoices were paid promptly. For example, “2/10, net/30”. This would give their customer a 2% discount if invoice is paid within 10 days. c.Instead of paying cash for their supplies, they should negotiate some credit terms with their suppliers. By doing b and c, they would hold on to cash earmarked for supplies a bit longer, while cash from customers comes in quicker. 3.The statement of cash flows for the month of March, May and July match up with the cash budget (w/o bank loan) prepared for question 1. This is as it should be. I setup another cash
budget that simulated the company getting a loan in April. This was done to clearly state when the loan could be paid off.