Excel File Edit Data Window Help 0 8 Thu Mar 31 12:20 PM View Insert Format Tools AFvG.. 672 AutoSave or OFF Spreadsheets 02 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me 9 Share Comments Calibri (Body 12 A A == Insert General ab Wrap Text HD Conditional Format Cell Formatting as Table Styles W YD. K) Paste B TU = = - Marge Canterv S% X Delete Formal 0: Sort & Filter Find & Select Analyze Data Sensitivity F10 . x fx A B E F G 1 1 J K L N o P R 5 U 2 3 4 Month April May June D Sales Forecast in thousands SOU 1000 2500 6 7 8 9 101 11 12 Al Sales are done on Credit and Collected a month later Inventory Levels will be maintained at the current levels Sales prices have been set using arark up over the costs of production of 25% % Sales and Admin Expenses are expected to remain constant Depreciation in thousandsl per monthis 12 Tax rate is the corporcelas rate of 215 Annual interest rate of outstanding debt is 18% Any new Debt annual interest rate 18% The company does not foresee any changes in equipment The desired And Cash Balance in thausands Existng Lang Term Debt will not change Average Price per unit in Dallas $ 14 15 100.00 17 18 50.00 What is thecompanies Survival revenues in Thousands How many unitis need for break Even? 20 21 22 23 24 25 Prepare financial Statements income statement, Cash Flow Statement and Balance Sheet for the Quarter cncing in June la Artual Mar Encing Quarter 27 28 29 30 31 32 33 Lull . Incurre Statement Sales COGS Gurss Profit Amounts in Thousands Projected Apr May June 700 560 140 49 12 79 Depreciation EBIT 35 Interest 1% of total borrowe mount ERT Net Income 12 67 14.07 52.93 37 14 Mar My une 46 47 48 49 Palabce Sheet Cash Accounts recievable Inventarle Current Assets Net Fixed Assets Apr 5. 800 500 1353 750 Type A Type B Type C Type D + Ready + 905 Excel File Edit Data Window Help 0 Q8 o Thu Mar 31 12:20 PM View Insert Format Tools AFvG.. 672 o. AutoSave or OFF Spreadsheets 02 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body! 12 A A InsArt == 19 Wrap Text General WA 27.0 LO) Paste B TU = = Merge & Center S% 03 9 Delete Formal Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity F10 X fx x e E H K L M N P R S T - Balabce Sheet D Aor F Jure Mer May 50 RCO 44 45 46 47 48 49 50 51 52 S3 54 SS 56 57 Accounts recievable Inventories Current Asses Net Fixed Asses Totalsts 500 1350 750 2100 0 0 Accounts Payable New Bank Laan Long Term Debt Total Liabilities Equity Total 1300 1300 2100 58 Create the Cash Flaw statement for the Month of luna and verify your ending cash Rwance or the balance Shee. The answers that you need to upload we only for this month 59 60 61 June 62 63 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 Cash Flow Cash Flow from Operations (Iperating Net Income Depreciation Changes Accts Receivable Changin Inventories Changes in Accts Payable Changes in Accruals CF from Operations Investing: Changes in Cross Fixed Assets Financing: Change Increase in Bank Loans ChangaInercase in Long-Term Dubi Cash Dividends Pid CF From Financing Change in Calance Cash Heg Period Change in C Cash at End period Type A Type B Type C Type D + Ready + 90% Excel File Edit Data Window Help 0 8 Thu Mar 31 12:20 PM View Insert Format Tools AFvG.. 672 AutoSave or OFF Spreadsheets 02 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me 9 Share Comments Calibri (Body 12 A A == Insert General ab Wrap Text HD Conditional Format Cell Formatting as Table Styles W YD. K) Paste B TU = = - Marge Canterv S% X Delete Formal 0: Sort & Filter Find & Select Analyze Data Sensitivity F10 . x fx A B E F G 1 1 J K L N o P R 5 U 2 3 4 Month April May June D Sales Forecast in thousands SOU 1000 2500 6 7 8 9 101 11 12 Al Sales are done on Credit and Collected a month later Inventory Levels will be maintained at the current levels Sales prices have been set using arark up over the costs of production of 25% % Sales and Admin Expenses are expected to remain constant Depreciation in thousandsl per monthis 12 Tax rate is the corporcelas rate of 215 Annual interest rate of outstanding debt is 18% Any new Debt annual interest rate 18% The company does not foresee any changes in equipment The desired And Cash Balance in thausands Existng Lang Term Debt will not change Average Price per unit in Dallas $ 14 15 100.00 17 18 50.00 What is thecompanies Survival revenues in Thousands How many unitis need for break Even? 20 21 22 23 24 25 Prepare financial Statements income statement, Cash Flow Statement and Balance Sheet for the Quarter cncing in June la Artual Mar Encing Quarter 27 28 29 30 31 32 33 Lull . Incurre Statement Sales COGS Gurss Profit Amounts in Thousands Projected Apr May June 700 560 140 49 12 79 Depreciation EBIT 35 Interest 1% of total borrowe mount ERT Net Income 12 67 14.07 52.93 37 14 Mar My une 46 47 48 49 Palabce Sheet Cash Accounts recievable Inventarle Current Assets Net Fixed Assets Apr 5. 800 500 1353 750 Type A Type B Type C Type D + Ready + 905 Excel File Edit Data Window Help 0 Q8 o Thu Mar 31 12:20 PM View Insert Format Tools AFvG.. 672 o. AutoSave or OFF Spreadsheets 02 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body! 12 A A InsArt == 19 Wrap Text General WA 27.0 LO) Paste B TU = = Merge & Center S% 03 9 Delete Formal Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity F10 X fx x e E H K L M N P R S T - Balabce Sheet D Aor F Jure Mer May 50 RCO 44 45 46 47 48 49 50 51 52 S3 54 SS 56 57 Accounts recievable Inventories Current Asses Net Fixed Asses Totalsts 500 1350 750 2100 0 0 Accounts Payable New Bank Laan Long Term Debt Total Liabilities Equity Total 1300 1300 2100 58 Create the Cash Flaw statement for the Month of luna and verify your ending cash Rwance or the balance Shee. The answers that you need to upload we only for this month 59 60 61 June 62 63 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 Cash Flow Cash Flow from Operations (Iperating Net Income Depreciation Changes Accts Receivable Changin Inventories Changes in Accts Payable Changes in Accruals CF from Operations Investing: Changes in Cross Fixed Assets Financing: Change Increase in Bank Loans ChangaInercase in Long-Term Dubi Cash Dividends Pid CF From Financing Change in Calance Cash Heg Period Change in C Cash at End period Type A Type B Type C Type D + Ready + 90%