EXCEL Work please guys help me with this assignment Develop a Budget Worksheet E

Question

EXCEL Work please guys help me with this assignment

Develop a Budget Worksheet

Excel is valuable to a wide audience of users: from accountants of Fortune 500 companies to

homeowners

managing their budgets. An Excel workbook can be a complex document, recording

data from thousands of financial transactions, or it can track a few monthly household expenses.

Anyone who has to balance a budget, track expenses, or project future income can use the

financial

tools in Excel to help them make good financial decisions about their financing and future

expenditures.

In this exercise, you will use Excel to create a sample budget workbook that will contain information

of your choice, using the Excel skills and features presented in Tutorials 1 through 4. Use the

following

steps as a guide to completing your workbook.

Note: Please be sure not to include any personal information of a sensitive nature in any workbooks

you create to be submitted to your instructor for this exercise. Later, you can update the workbooks

with such information for your personal use.

1. Gather the data related to your monthly cash inflows and outflows. For example, how much

do you take home in your paychecks each month? What other sources of income do you

have? What expenses do you have

Explanation / Answer

BUDGET WORKSHEET:

Cash flows :

Pie Chart:

Line chart for savings, month-wise:

Monthly income from salary 80,000 Monthly expenses Car EMI 15,000 Rent 10,000 Power bill 5,000 Life insurance 1,000 Child's education 1,000 Groceries 780 electricity 890 entertainment 960 Total expenses 34,630

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.