Reference no: EM133379814
Question: Short Term Financial Planning You work for the Treasurer of BE Products, Inc. Your team is responsible for short term capital management. You are asked to work on the following tasks (please use the provided excel template to outline your answer to each).
Consider the two tasks completely independent (i.e. do not use info from one when you solve for the other). 1. Consider the following financial statement information for YYYY Products, Inc. Item Beginning Ending Inventory $ 16,284 $ 19,108 A/R $ 11,219 $ 13,973 A/P $ 13,960 $ 16,676 Net sales $ 219,320 COGS $ 168,420 Calculate the operating and cash cycles. How do you interpret your answer? 2. Your boss has just been asked by the company's president to prepare a memo detailing the company's ending cash balance for the next three months. Below, you will see the relevant estimates for this period. July August September Credit sales $ 1,275,800 $ 1,483,500 $ 1,096,300 Credit purchases 765,480 890,160 657,780 Cash disbursements: Wages, taxes, and expenses 348,600 395,620 337,150 Interest 29,900 29,900 29,900 Equipment - 158,900 96,300 Credit sales collections: Collected in month of sale: 35% Collected month after sale: 60% Never collected: 5% 5 June credit sales: $ 1,135,020 June credit purchases: $ 681,012 Beginning cash balance: $ 425,000 All credit purchases are paid in the month after the purchase.
Complete the cash budget for BE Products for the next three months (July, August, September)