Please use the data from the following table to complete the cash budget in Excel spreadsheets. You can use the Excel file (FINA 3562 Project 2 data.xlsx) I uploaded on Blackboard. To complete the cash budget, you will have to work on the schedules of expected cash collections and payments first. Please set formulae by referencing to the data in Excel spreadsheets. If you do not meet this requirement, you will be asked to re-work on the project. You can work with another student on this project or work alone. Please put your name(s) in your Excel spreadsheets. This project accounts for 5% of your overall grade. Due date: March 8th, 11:59 pm on Blackboard The following table lists the data from the budget of Dynamic Mattress Company. 35% the companys sales are for cash on the nail; the other 65% are paid for with a one-month delay. The company pays all its credit purchase with a one-month delay. Credit purchases in January were $120,000, and total sales in January were $560,000. Dynamic Mattress Sales, purchase, and other budgets January February March April Total sales $ 560,000 $512,000 $ 745,000 $ 850,000 Purchases of material For cash 150,000 160,200 156,600 For credit 120,000 110,000 106,800 104,400 Labor and other expenses 138,000 138,000 138,000 Selling and admin. expenses 80,000 80,000 80,000 Income taxes 46,000 46,000 46,000 Dividends 7,000 7,000 7,000 Equipment purchase 95,000 8,000 14,500 We make these assumptions to simplify the analysis: * Dynamic Mattress Company has an open line of credit with its bank, which can be used as needed to bolster the cash position. * The company desires to maintain a $22,000 minimum cash balance at the end of each month. Therefore, borrowing must be sufficient to cover the cash shortfall and to provide for the minimum cash balance of $22,000. * All borrowings and repayments must be in multiples of $1,000 amounts, and interest is 5 percent per annum. 2 * Interest is computed and paid on the principal during the borrowing period. Interest payments will be made at the end of March and April. * All borrowings take place at the beginning of a month, and all repayments are made at the end of a month. The company will take a loan at the beginning of February, repaying part of the loan at the end of March and the remaining balance at the end of April. You have to figure out the loan amount and repayment amounts. Repayment in March is based on available cash from operating activities. * The company pays labor and other expenses, selling and administrative expenses, income taxes, dividends, and pays for equipment purchase at the end of a month. You can refer to the examples in this chapter for how to make a cash budget.

Please use the data from the following table to complete the cash budget in Excel spreadsheets. You can use the Excel file (FINA 3562 Project 2 data.xlsx) uploaded on Blackboard. To complete the cash budget, you will have to work on the schedules of expected cash collections and payments first. Please set formulae by referencing to the data in Excel spreadsheets. If you do not meet this requirement, you will be asked to re-work on the project. You can work with another student on this project or work alone. Please put your name(s) in your Excel spreadsheets. This project accounts for 5% of your overall grade. Due date: March 8th, 11:59 pm on Blackboard The following table lists the data from the budget of Dynamic Mattress Company. 35% the company's sales are for cash on the nail; the other 65% are paid for with a one-month delay. The company pays all its credit purchase with a one-month delay. Credit purchases in January were $120,000, and total sales in January were $560,000. Dynamic Mattress rchase, and other budgets Janu Sales March 745,000 April 850,000 Februa Total sales Purchases of material 560,000512,000 For cash 150 For credit Labor and other expenses Selling and admin. expenses ncome taxes Dividends 160,200 106,800 138,000 80,000 46,000 7,000 8,000 156,600 104,400 138,000 80,000 46,000 7,000 120,000110,000 138 80,000 46,000 7,000 95,000 ase 14 We make these assumptions to simplify the analysis: Dynamic Mattress Company has an open line of credit with its bank, which can be used as needed to bolster the cash position. The company desires to maintain a $22,000 minimum cash balance at the end of each month. Therefore, borrowing must be sufficient to cover the cash shortfall and to provide for the minimum cash balance of $22,000. All borrowings and repayments must be in multiples of $1,000 amounts, and interest is 5 percent per annum. Please use the data from the following table to complete the cash budget in Excel spreadsheets. You can use the Excel file (FINA 3562 Project 2 data.xlsx) uploaded on Blackboard. To complete the cash budget, you will have to work on the schedules of expected cash collections and payments first. Please set formulae by referencing to the data in Excel spreadsheets. If you do not meet this requirement, you will be asked to re-work on the project. You can work with another student on this project or work alone. Please put your name(s) in your Excel spreadsheets. This project accounts for 5% of your overall grade. Due date: March 8th, 11:59 pm on Blackboard The following table lists the data from the budget of Dynamic Mattress Company. 35% the company's sales are for cash on the nail; the other 65% are paid for with a one-month delay. The company pays all its credit purchase with a one-month delay. Credit purchases in January were $120,000, and total sales in January were $560,000. Dynamic Mattress rchase, and other budgets Janu Sales March 745,000 April 850,000 Februa Total sales Purchases of material 560,000512,000 For cash 150 For credit Labor and other expenses Selling and admin. expenses ncome taxes Dividends 160,200 106,800 138,000 80,000 46,000 7,000 8,000 156,600 104,400 138,000 80,000 46,000 7,000 120,000110,000 138 80,000 46,000 7,000 95,000 ase 14 We make these assumptions to simplify the analysis: Dynamic Mattress Company has an open line of credit with its bank, which can be used as needed to bolster the cash position. The company desires to maintain a $22,000 minimum cash balance at the end of each month. Therefore, borrowing must be sufficient to cover the cash shortfall and to provide for the minimum cash balance of $22,000. All borrowings and repayments must be in multiples of $1,000 amounts, and interest is 5 percent per annum