Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
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

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_2

Step: 3

blur-text-image_3

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

Authors: Warren, Reeve, Duchac

12th Edition

1133952410, 9781133952411, 978-1133952428

More Books

Students also viewed these Accounting questions