entify the cash inflows and the cash outflows and insert them in the space on the right. propriately format the cash budget. "he attached MS-Word document has a potentail format. Hou can use the form on the right right or start from scratch. Information for Preparation of cash budget: + Sales Actual Projected Projected Dec 2020 Projected January 2021 February 2021 March 2021 S50.000 $70,000 $65.000 $110.000 7 8 Operating Disbursements 19 20 Projected Projected January 2021 21 Projected February 2021 March 2021 22 $72.000 $70,000 $56.000 23 24 Sales are 25% cash and 75% on credit. Credit sales are collected in the next month. 25 26 The company received a $100,000 term-loan in December of 2020. Payments begin in 27 January 2021. An amortization schedule for the term-loan payable is below. 28 29 "The company has approval for a $150,000 line of credit. The balance on January 1, 2020 #1 CVP 12 Cash Budget #3 Fin Analysis #4 TVM Forma RO Projected January 2021 $72,000 Projected February 2021 $70,000 Projected March 2021 $56,000 Sales are 25% cash and 75% on credit. Credit sales are collected in the next month. - The company received a $100,000 term-loan in December of 2020. Payments begin in January 2021. An amortization schedule for the term-loan payable is below. The company has approval for a $150,000 line of credit. The balance on January 1, 2020 is zero. The company wishes to maintain a minimum cash balance of $10,000 at the end of each month. Any cash in excess of $10,000 will be used to pay down the balance on the line of credit. The beginning cash balance is $15,000 on January 1, 2020 K $22,645.44 $1,887.12 $4,589.98 $13,227.20 $113,227.20 Inputs Key Figures Loan principal amount $100,000.00 Annual loan payments Annual interest rate 5.0% Monthly payments Loan period in years 5 Interest in first calendar year Base year of loan 2020 Interest over term of loan 3 Base month of loan January Sum of all payments 9 Payments in First 12 Months 50 51 Year Month Beginning Balance Payment 52 Principal Interest Ending Balance 2020 53 Jan $100,000.00 $1,887.12 $1,470.45 $416.67 Feb $98,529.55 54 $98,529.55 $1,887.12 $1,476.58 Mar $410.54 $97,052.97 $97,052.97 55 $1,887.12 $1,482.73 Apr $104.39 $95,570.24 $95,570.24 $1,887.12 $1,488.91 $398.21 $94,081.33 $94,081.33 $1,887.12 $1,495.11 57 Jun $392.01 $92,586.22 $92,586.22 $1,887.12 $1,501,34 Jul $385.78 58 $91,084.88 $91,084.88 $1,887.12 $1,507.60 $379.52 59 Aug $89,577.28 $89,577.28 $1,887.12 $1,513.88 Sep $373.24 $88,063.40 60 $88,063.40 $1,887.12 $1,520.19 $366,93 Oct $86,543.21 $86,543.21 61 $1,887.12 $1,526.52 $360.60 $85,016,69 Nov $85,016.69 62 $1,887.12 $1,532.88 $354.24 $83,183-N Dec $83,483.81 63 $1,887.12 $1,539.27 $347.85 $81,944.54 64 65 Yearly Schedule of Balances and Payments 66 67 Year Beginning Balance Payment Principal Interest Ending Balance 2021 $81,944.54 $22,645.44 $18,979.46 $3,665.98 $62,965.08 69 2022 $62,965.08 $22,645.44 $19,950.26 $2,695,18 $43,014.82 70 2023 $13,014.82 $22,615.44 $20,970.95 $1,674.49 $22.043.87 71 2024 $22.013.82 $22,645.44 $22,043.87 $601.57 $0.00 72 56 May N O P Q S R Feb T Dec Jan Mar Total Sales Cash Credit Nova Corp Cash Budget January to March 2020 Jan. Feb. Mar. Total Cash Inflows Cash Sales Colections of credit Sales Cash Outflows Operating payments Loan Payments Net Cash Flow Beginning Cash Increase (Decrease) in Line of Credit Endine Cash Sh Outflows Operating payments Loan Payments Net Cash Flow Beginning Cash Increase (Decrease) in Line of Credit Ending Cash Balance of line of Credit