Question: how to do part 1 excel Prepare a monthly eash budget for the last six asonths of the year (July to Deeember). Cash gain or

Prepare a monthly eash budget for the last six asonths of the year (July to Deeember). Cash gain or loss for monzh 40. Collections 41 Payments for taber and raw materials. \begin{tabular}{rrrrrrr} 50 & 50 & 50 & 50 & 50 & 50 \\ \hline 0 & 0 & 0 & 0 & 0 & 0 \end{tabular} 42. General and administrative salaries 43. Lease payments Depredation Misedlancous expenser Income tax payments Design studio payment 48. Total paymonts 49 Net eash gain (loss) duriag msoath \begin{tabular}{|llllll} \hline$0 & $0 & $0 & $0 & $0 & $0 \\ \hline 50 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} Lade requirement or cash surplas 52. Cash at start of month (witheut berrowing) 53 Cumelative eash at end of month (without borroning). \begin{tabular}{|llllll} \hline 50 & 50 & $0 & 50 & $0 & 50 \end{tabular} 54 Target cash balance 55 Camulative surplus cash or loans 56 eutatading to maintain $90,000 target eash balnace 57 58 59 59 Max. Lean 50
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
