Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

help asappp!!!!
PLEASE
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An International Introduction

Authors: David Alexander, Christopher Nobe

6th Edition

1292102993, 978-1292102993

More Books

Students also viewed these Accounting questions