WebCash is King: Master Budgets to Inform a Credit Decision. 1. Using the data input provided (Exhibit 1), prepare LAF’s master budgets in Excel. Do not hard-code numbers into the spreadsheet, except in the financing section of the cash budget. 2. Conduct a sensitivity analysis, decreasing sales 2%, 5%, and 10% for April through August. WebIn the example of Kent Bank, the firm wants to analyze the financial situation of Little Annin Flagmakers by understanding how a drop in sales would affect the company. The analysis would showcase the effect of the change in the company's sales on the different financial statements and factors, particularly cash and financial budgets.
Unit 4 Assignment - Budgeting (Managerial Accounting)
WebLittle Annin Flagmakers Sales Budget (US$) April May Budgeted sales (units) 2,500 6,000 Selling price per unit $120 $120 Total Sales $ 300,000 $ 720,000 Little Annin Flagmakers Schedule of Expected Cash Collecti April May Accounts receivable Beginning balance $ 132,000 April sales $ 120,000 $ 165,000 May sales $ 288,000 June sales Total Cash … WebAnnin Flagmakers has been making the US Flag since 1847 and is the oldest and largest flag manufacturer in the United States. We have the highest-quality products, broadest … hollimon law firm madison ms
Home - Annin Flagmakers
WebAll sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. WebCash is King: Master Budgets to Inform a Credit Decision1 Introduction Early one morning in March, Jordan Buford was preparing his daily work when his boss, Olivia Anton, approached him and announced, “Little Annin Flagmakers (LAF) has submitted an application for a line of credit (LOC) for April through June. WebLittle Annin Flagmakers: Blue - you may hard-key numbers in these cells: Sales Budget (US$) April: May: June: Quarter: Budgeted sales (units) Selling price per unit: Total Sales: Little Annin Flagmakers: Schedule of Expected Cash Collections (US$) April: May: June: Quarter: Accounts receivable: Beginning balance: April sales: May sales: June ... human platelet isolation kit