make cash budget!!

The company Pets whose financial statements for the year ended December 31, 2018 are presented below:

In addition to the above information, we have the following data provided by the licensed Alfonso Lopez, controller of the company, in relation to the operations of the year 2018:

Sales of $ 1,100,000 are expected in 2019. Expected to have sales of $ 100,000 Gross margin (Gross profit / sales) will remain unchanged The tax rate will be equal to 40% of the profit before taxes, and the total will be paid in 2019 The depreciation expense is $ 40,000 (included as an operating expense) Operating expenses will not change compared to 2018 Mortgage credit payments will be made. Of the total payments that will be made ($ 70,000), $ 40,000 correspond to interest and the rest to amortization of the principal During 2019 you want to maintain a balance of $ 20,000 in cash.

Pets Statement of income from January 1 to December 31, 2018 Sales 1000000 Sales cost 600000 Gross profit 400000 Operating costs 150000 Operation profit 250000 Financial expenses 45000 Profit before taxes 205000 Taxes 82000 Net profit 123000 116000 123000 239000 Pets Balance sheet from January 1 to December 31, 2018 Active passive Current assets Short term Cash 22000 Providers Customers 100000 Taxes to pay Inventory 80000 Total short-term liabilities Total current assets 202000 Long-term Mortgage Fixed asset Total long-term liabilities Land 500000 Total liabilities Machinery and equipment 800000 Accumulated depreciation -400000 Stockholders' equity Total fixed assets 900000 Social capital Retained earnings Total equity Total assets 1102000 Total liabilities + equity * 2018 starting inventory was $ 100,000 300000 300000 539000 250000 313000 563000 1102000 Pets Statement of income from January 1 to December 31, 2018 Sales 1000000 Sales cost 600000 Gross profit 400000 Operating costs 150000 Operation profit 250000 Financial expenses 45000 Profit before taxes 205000 Taxes 82000 Net profit 123000 116000 123000 239000 Pets Balance sheet from January 1 to December 31, 2018 Active passive Current assets Short term Cash 22000 Providers Customers 100000 Taxes to pay Inventory 80000 Total short-term liabilities Total current assets 202000 Long-term Mortgage Fixed asset Total long-term liabilities Land 500000 Total liabilities Machinery and equipment 800000 Accumulated depreciation -400000 Stockholders' equity Total fixed assets 900000 Social capital Retained earnings Total equity Total assets 1102000 Total liabilities + equity * 2018 starting inventory was $ 100,000 300000 300000 539000 250000 313000 563000 1102000