70.2K

Verified Solution

Link Copied!

help asappp!!!!

PLEASE

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{9}{|l|}{ Excel Project (20 points). } \\ \hline & & & & & & & & \\ \hline \multicolumn{9}{|c|}{ Please prepare your own vision of your first three months' 2020 budget and charts. } \\ \hline \multicolumn{9}{|c|}{ Please include the following. 1\} Gridlines on the budget, but not on the charts ... use more than 1 sheet. } \\ \hline \multicolumn{9}{|c|}{ 2) Sums for the "Totals" and formulae to calculate the bottom three items. } \\ \hline \multicolumn{9}{|c|}{ 3) Statistical functions for the 'Minimum", "Maximum", and "Averages" } \\ \hline \multicolumn{9}{|c|}{ 4) Comments for the "Minimum" and "Maximum" revenues and expenses } \\ \hline \multicolumn{9}{|c|}{ 5) \$ on the top numbers and commas on all numbers; shading for titles. } \\ \hline \multicolumn{9}{|c|}{ 6) Calculation of "\% of Total" with the "E12/SES19" format so that copyine works } \\ \hline \multicolumn{9}{|c|}{\begin{tabular}{l|l|l|l|} 7) All of the charts that I provided as examples & & & \end{tabular}} \\ \hline \multicolumn{9}{|c|}{ 8) Use Conditional Formatting so that all Revenue numbers greater than $1000 are Green } \\ \hline & and numbe & rs less than & is $1000 are & Red & & & & \\ \hline \multicolumn{9}{|c|}{ 9) Set Margins to 5 for Top and Bottom, 1.25 for Left and Right, and 1 for Header and Foote } \\ \hline \multicolumn{9}{|c|}{ 10) Merge and Left Align the Titles of the Worksheet . } \\ \hline & & \multicolumn{3}{|c|}{ Your Namel } & & & & \\ \hline & & \multicolumn{3}{|c|}{2020 sudget } & & & & \\ \hline Revenues & January & February & March & Total & % of Tolat & Minimum & Moximum & Average \\ \hline Ecucator Revenues & $6,000 & $5,000 & $5,000 & $16,000 & 6.65% & $5.000 & $6,000 & 55,333 \\ \hline CPA Revenues & 1,000 & 1,000 & 1,000 & 3,000 & 1.25% & 1,000 & 1,000 & 1,000 \\ \hline Riental Revenue & 500 & 500 & 500 & 1,500 & 0.62% & 500 & 500 & 500 \\ \hline Unreaized Gains on lnvestinents. & 20,000 & 22,000 & 27,000 & 69,000 & 28.68% & 20,000 & 27,000 & 23,000 \\ \hline Realized Gains on imvestments & 2,000 & 0 & 0 & 2,000 & 0.83% & - & 2,000 & 667 \\ \hline interessDividend Aevenue & 7.000 & 8,000 & 9.000 & 24,000 & 9.97% & 7.000 & 9,000 & 8000 \\ \hline Miscelaneous inscome & 50 & 75 & 125.000 & 125,125 & 5200% & 50 & 125,000 & 41,708 \\ \hline Total Revenues & 36,550 & 36,575 & 167.500 & 240,625 & 100.00% & 36.550 & 167.500 & 80.208 \\ \hline \multicolumn{9}{|l|}{ Expenses: } \\ \hline Taxes (\$S and Property) & 30,000 & 500 & 500 & 31,000 & 12.89% & 500 & 10,000 & 10,333 \\ \hline Chartable Donabona & 0 & 5,000 & 50,000 & 55,000 & 22.86N & . & 50,000 & 18.333 \\ \hline CAildren' Expenses & 2,500 & 4,000 & 10,000 & 16,560 & 6.80% & 2,500 & 10,020 & 5.500 \\ \hline Edicarional Eipenses & 3,000 & 500 & 500 & 4,000 & 1.66% & 500 & 3,000 & 1,333 \\ \hline Franspertation Expenses & 500 & 500 & 500 & 1,500 & 0.62% & 500 & 500 & sen \\ \hline Medical & 10 & 50 & 100 & 160 & 0.07% & 10 & 100 & 53 \\ \hline Leities & 200 & 150 & 150 & 500 & 0.21% & 150 & 200 & 16y \\ \hline ineuration & 250 & 250 & 250 & 750 & 0.31% & 250 & 250 & 250 \\ \hline Fosd & 100 & 150 & 200 & 450 & 0.19% & 100 & 200 & 150 \\ \hline Cloching and Persons aems & 50 & 100 & 500 & 6S0 & 0.27% & 50 & 500 & 217 \\ \hline Depredatan & 2.000 & 2,000 & 2.000 & 6,000 & 2.49% & 2.000 & 2,000 & 2,000 \\ \hline Leisuen & 0 & 50 & 500 & 350 & 0.23% & . & 500 & 183 \\ \hline Lale Med-1le Crials & 0 & 0 & 50.000 & 50,000 & 20.78% & & 50,000 & 16,667 \\ \hline Todal Expenses & 38.610 & 13,250 & 115.200 & 167,060 & 60.43% & 13,250 & 115,200 & 55,687 \\ \hline irisome Before Tuxas & 2,060 & 23.325 & 52.300 & 73,565 & 30.57% & (2,000) & 52,300 & 24,522 \\ \hline Proviabin far incone Tame (ad) & -412 & 4665 & 10460 & 14,713 & 0.11% & (412) & 10,460 & 4,904 \\ \hline Net Income & 1,048 & 10,600 & 41,840 & 58,852 & 24.40% & (1,048) & 41,840 & 19.611 \\ \hline \end{tabular} Monthly Comparisons of Top 5 Expenses - Taxes (\$5 and Properiy) e Charitable Donations. a Late Med-life Crichs a Children's Expentes - Depreciation a Fducational Lepenses a Transportetion Eupenses e insurance Cloching and Personul items teloure Utilites Food Medical Februry March Sources of Revenue - Cduciater Aevanues = CPA Reverues - Mental hevenue - Unerealued Cains en inveatrints - Aeahued cieiri on inveroments E Misenilanease thiome \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{9}{|l|}{ Excel Project (20 points). } \\ \hline & & & & & & & & \\ \hline \multicolumn{9}{|c|}{ Please prepare your own vision of your first three months' 2020 budget and charts. } \\ \hline \multicolumn{9}{|c|}{ Please include the following. 1\} Gridlines on the budget, but not on the charts ... use more than 1 sheet. } \\ \hline \multicolumn{9}{|c|}{ 2) Sums for the "Totals" and formulae to calculate the bottom three items. } \\ \hline \multicolumn{9}{|c|}{ 3) Statistical functions for the 'Minimum", "Maximum", and "Averages" } \\ \hline \multicolumn{9}{|c|}{ 4) Comments for the "Minimum" and "Maximum" revenues and expenses } \\ \hline \multicolumn{9}{|c|}{ 5) \$ on the top numbers and commas on all numbers; shading for titles. } \\ \hline \multicolumn{9}{|c|}{ 6) Calculation of "\% of Total" with the "E12/SES19" format so that copyine works } \\ \hline \multicolumn{9}{|c|}{\begin{tabular}{l|l|l|l|} 7) All of the charts that I provided as examples & & & \end{tabular}} \\ \hline \multicolumn{9}{|c|}{ 8) Use Conditional Formatting so that all Revenue numbers greater than $1000 are Green } \\ \hline & and numbe & rs less than & is $1000 are & Red & & & & \\ \hline \multicolumn{9}{|c|}{ 9) Set Margins to 5 for Top and Bottom, 1.25 for Left and Right, and 1 for Header and Foote } \\ \hline \multicolumn{9}{|c|}{ 10) Merge and Left Align the Titles of the Worksheet . } \\ \hline & & \multicolumn{3}{|c|}{ Your Namel } & & & & \\ \hline & & \multicolumn{3}{|c|}{2020 sudget } & & & & \\ \hline Revenues & January & February & March & Total & % of Tolat & Minimum & Moximum & Average \\ \hline Ecucator Revenues & $6,000 & $5,000 & $5,000 & $16,000 & 6.65% & $5.000 & $6,000 & 55,333 \\ \hline CPA Revenues & 1,000 & 1,000 & 1,000 & 3,000 & 1.25% & 1,000 & 1,000 & 1,000 \\ \hline Riental Revenue & 500 & 500 & 500 & 1,500 & 0.62% & 500 & 500 & 500 \\ \hline Unreaized Gains on lnvestinents. & 20,000 & 22,000 & 27,000 & 69,000 & 28.68% & 20,000 & 27,000 & 23,000 \\ \hline Realized Gains on imvestments & 2,000 & 0 & 0 & 2,000 & 0.83% & - & 2,000 & 667 \\ \hline interessDividend Aevenue & 7.000 & 8,000 & 9.000 & 24,000 & 9.97% & 7.000 & 9,000 & 8000 \\ \hline Miscelaneous inscome & 50 & 75 & 125.000 & 125,125 & 5200% & 50 & 125,000 & 41,708 \\ \hline Total Revenues & 36,550 & 36,575 & 167.500 & 240,625 & 100.00% & 36.550 & 167.500 & 80.208 \\ \hline \multicolumn{9}{|l|}{ Expenses: } \\ \hline Taxes (\$S and Property) & 30,000 & 500 & 500 & 31,000 & 12.89% & 500 & 10,000 & 10,333 \\ \hline Chartable Donabona & 0 & 5,000 & 50,000 & 55,000 & 22.86N & . & 50,000 & 18.333 \\ \hline CAildren' Expenses & 2,500 & 4,000 & 10,000 & 16,560 & 6.80% & 2,500 & 10,020 & 5.500 \\ \hline Edicarional Eipenses & 3,000 & 500 & 500 & 4,000 & 1.66% & 500 & 3,000 & 1,333 \\ \hline Franspertation Expenses & 500 & 500 & 500 & 1,500 & 0.62% & 500 & 500 & sen \\ \hline Medical & 10 & 50 & 100 & 160 & 0.07% & 10 & 100 & 53 \\ \hline Leities & 200 & 150 & 150 & 500 & 0.21% & 150 & 200 & 16y \\ \hline ineuration & 250 & 250 & 250 & 750 & 0.31% & 250 & 250 & 250 \\ \hline Fosd & 100 & 150 & 200 & 450 & 0.19% & 100 & 200 & 150 \\ \hline Cloching and Persons aems & 50 & 100 & 500 & 6S0 & 0.27% & 50 & 500 & 217 \\ \hline Depredatan & 2.000 & 2,000 & 2.000 & 6,000 & 2.49% & 2.000 & 2,000 & 2,000 \\ \hline Leisuen & 0 & 50 & 500 & 350 & 0.23% & . & 500 & 183 \\ \hline Lale Med-1le Crials & 0 & 0 & 50.000 & 50,000 & 20.78% & & 50,000 & 16,667 \\ \hline Todal Expenses & 38.610 & 13,250 & 115.200 & 167,060 & 60.43% & 13,250 & 115,200 & 55,687 \\ \hline irisome Before Tuxas & 2,060 & 23.325 & 52.300 & 73,565 & 30.57% & (2,000) & 52,300 & 24,522 \\ \hline Proviabin far incone Tame (ad) & -412 & 4665 & 10460 & 14,713 & 0.11% & (412) & 10,460 & 4,904 \\ \hline Net Income & 1,048 & 10,600 & 41,840 & 58,852 & 24.40% & (1,048) & 41,840 & 19.611 \\ \hline \end{tabular} Monthly Comparisons of Top 5 Expenses - Taxes (\$5 and Properiy) e Charitable Donations. a Late Med-life Crichs a Children's Expentes - Depreciation a Fducational Lepenses a Transportetion Eupenses e insurance Cloching and Personul items teloure Utilites Food Medical Februry March Sources of Revenue - Cduciater Aevanues = CPA Reverues - Mental hevenue - Unerealued Cains en inveatrints - Aeahued cieiri on inveroments E Misenilanease thiome

Answer & Explanation Solved by verified expert

See Answer