Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me, im not understanding this Begin your annual budget by reviewing your financial goal, the time frame you'd like to complete your goal
Please help me, im not understanding this
Begin your annual budget by reviewing your financial goal, the time frame you'd like to complete your goal in, and your housing option. Your selections will automatically fill into the spreadsheet below. My financial goal: My time frame: My housing: Now, fill in the rest of your expenses and make calculations using Excel formulas and functions in the spreadsheet below. 10:49 Done EC0110 - Page 6.9 - C... 11. CONTENTS TAKING CHARGE OF O. . \begin{tabular}{|l|l|l|} \hline 7 & Dollars & Percentage of \\ \hline & & Inthiscolumn,divisionformul;percentageoft \\ \hline 8 & $7,125 & foreachexpen:example,inthis=B8/B6todivid \\ \hline 9 & $2,500 & Calculate the pi \\ \hline 10 & $20,000 & \\ \hline \end{tabular} 11$15,000 Calculate the p Enter your estimated yearly 12 utilities expense without a $ Calculate the p. or comma. Enter your estimated yearly 13 health care expense without Calculate the pi a S or comma. Enter your estimated yearly 14 car loan expense without a Caiculate the pi $ or comma. Enter your estimated yearly 15 phone expense without a \$ Calculate the p: 10:49 LTE 89 Done ECO110 - Page 6.9-C... 1. CONTENTS TAKING CHARGE OF ... \begin{tabular}{l|l|l|} 16 & UsetheSUMfunctiontoaddallfixedexpenses. & Calculate the pi \\ \hline 17 & Dollars & Percentage of \\ \hline \end{tabular} Enter your estimated yearly 18 food expense without a $ or Calculate the p i comma. Enter your estimated yearly 19 car maintenance and gas Calculate the p expense without a S or comma. Enter your estimated yearly 20 personal care expense without a \$ or comma. Enter your estimated yearly 21 entertainment expense Calculate the p. without a S or comma. Enter your estimated yearly 22 miscellaneous expense Calculate the p : without a $ or comma. 23 Use the SUM function to add all variable expenses. Calculate the p Use the addition formula to 24 add total fixed expenses Calculate than and total variable expenses. Use the subtraction formula Begin your annual budget by reviewing your financial goal, the time frame you'd like to complete your goal in, and your housing option. Your selections will automatically fill into the spreadsheet below. My financial goal: My time frame: My housing: Now, fill in the rest of your expenses and make calculations using Excel formulas and functions in the spreadsheet below. 10:49 Done EC0110 - Page 6.9 - C... 11. CONTENTS TAKING CHARGE OF O. . \begin{tabular}{|l|l|l|} \hline 7 & Dollars & Percentage of \\ \hline & & Inthiscolumn,divisionformul;percentageoft \\ \hline 8 & $7,125 & foreachexpen:example,inthis=B8/B6todivid \\ \hline 9 & $2,500 & Calculate the pi \\ \hline 10 & $20,000 & \\ \hline \end{tabular} 11$15,000 Calculate the p Enter your estimated yearly 12 utilities expense without a $ Calculate the p. or comma. Enter your estimated yearly 13 health care expense without Calculate the pi a S or comma. Enter your estimated yearly 14 car loan expense without a Caiculate the pi $ or comma. Enter your estimated yearly 15 phone expense without a \$ Calculate the p: 10:49 LTE 89 Done ECO110 - Page 6.9-C... 1. CONTENTS TAKING CHARGE OF ... \begin{tabular}{l|l|l|} 16 & UsetheSUMfunctiontoaddallfixedexpenses. & Calculate the pi \\ \hline 17 & Dollars & Percentage of \\ \hline \end{tabular} Enter your estimated yearly 18 food expense without a $ or Calculate the p i comma. Enter your estimated yearly 19 car maintenance and gas Calculate the p expense without a S or comma. Enter your estimated yearly 20 personal care expense without a \$ or comma. Enter your estimated yearly 21 entertainment expense Calculate the p. without a S or comma. Enter your estimated yearly 22 miscellaneous expense Calculate the p : without a $ or comma. 23 Use the SUM function to add all variable expenses. Calculate the p Use the addition formula to 24 add total fixed expenses Calculate than and total variable expenses. Use the subtraction formula Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started