Kopitano is a startup a coffee shop. Assist Kopitano in preparing the cash budget from June...

Transcribed Image Text:

Kopitano is a startup a coffee shop. Assist Kopitano in preparing the cash budget from June to September. The company has projected sales and expenses as follows: Month June July August September Sales (RM) Expenses Rentals Utilities 55,000 58,500 79,000 80,000 Historically, 30 percent of sales have been for cash and the remaining 70 percent are collected one month after sale. Depreciation Wages Purchases (RM) 40,000 55,000 58,000 45,000 60 percent of the purchase price is paid in cash and the balance 40 percent of the purchase price will be paid on month later. Fixed monthly expenses for Kopitano are: RM 4,000 2,800 8,000 2,500 In June, Kapitano expects to receive a RM5,000 dividend from its investment in a local mutual fund, while in August, Kapitano plans to renew its insurance policy and has to pay RM5,000 for that purpose. Kapitano also plans to pay its tax amounted RM3,000 in July and bonus will be pay in September, RM7,500. Kapitano's cash balance as at June was RM20,000 and a minimum of RM15,000 must be maintained at all times. Kapitano's borrowing subjected to 24 percent per annum interest rate. Prepare a complete financial planning for the months of July, August and September Kopitano. Kopitano is a startup a coffee shop. Assist Kopitano in preparing the cash budget from June to September. The company has projected sales and expenses as follows: Month June July August September Sales (RM) Expenses Rentals Utilities 55,000 58,500 79,000 80,000 Historically, 30 percent of sales have been for cash and the remaining 70 percent are collected one month after sale. Depreciation Wages Purchases (RM) 40,000 55,000 58,000 45,000 60 percent of the purchase price is paid in cash and the balance 40 percent of the purchase price will be paid on month later. Fixed monthly expenses for Kopitano are: RM 4,000 2,800 8,000 2,500 In June, Kapitano expects to receive a RM5,000 dividend from its investment in a local mutual fund, while in August, Kapitano plans to renew its insurance policy and has to pay RM5,000 for that purpose. Kapitano also plans to pay its tax amounted RM3,000 in July and bonus will be pay in September, RM7,500. Kapitano's cash balance as at June was RM20,000 and a minimum of RM15,000 must be maintained at all times. Kapitano's borrowing subjected to 24 percent per annum interest rate. Prepare a complete financial planning for the months of July, August and September Kopitano.

Answer rating: 100% (QA)

Kopitano A cash budget is a document produced to help a business manage their cash flow A cash budge... View the full answer