Business Finance : I need help with my assignment excel assignment

Excel Mini Project

Attached Files:

Create a " Personal Monthly Budget", similar to the " Sample Budget " posted this week, that covers your financial resources and expenses.

Instructions:

  • Use the Sample Budget, the PDF file that is posted in the Weekly Content area and Week 13: April 16link to frame your personal budget spreadsheet. A copy of this PDF file is attached for your convenience.
  • Note that the Sample Budget is set for one yearand your Mini Project is for one month! (Pay attention to the difference) - 25 points
  • Add as many expense items as possible so you can have a good scenario for the What-If Analysis part.
  • In the end, show your savings or your extra income/shortage that you need to balance your monthly budget. - 25 point
  • Finally, perform a What-if Analysis (Goal Seek) of the amount of Saving based on your own scenario. - 10 points
  • You should have 2 Sheet tabsin your spreadsheet file. Rename Sheet1 to " Original Personal Budget" to save your original budget sheet and Sheet2 to " Personal Budget Analysis" to save a copy of your budget sheet and perform the What-if Analysis (Goal Seek)in this one.
  • Make sure to have all formulas where needed. Missing any single formula will cost you points. - 40 points
  • Upload your Excel file into Bb for grading by the next session ( April 23)

Answers

Related Questions

Slides ppt...

 his week, you will consolidate the written exercises from Week 1 to Week 5 based on your personal journal entries and prepare a Microsoft PowerPoint...

Discussion response ebp and nami organization...

  The National Alliance of Mental Illness  (150-word response)The National Alliance on Mental Illness (NAMI) was founded in 1979 in Madison Wiscons...

Acc 205 week 5 exercise...

  Financial RatiosPlease complete each of the exercises below in a word document. Save the document, and submit to in week using the Assignment Subm...

Easy work in 3 and half hour...

   The Influence of Family on Body ImageAccording to your textbook, body image can be defined as “what you believe or emotionally feel about your...

Cilr...

Literature Review: You will do 6 literature reviews pretaining to your specific course and topic. Reviews literature related to the unifying/overarchi...

Strategic management group project 5...

ToolsCorp Corporation is a fictitious company that does exist anywhere. For the purpose of this course, it is located it in Tennessee. As members of t...

Dq tech and art...

We normally think of the arts as very different from technologies in spite of the fact that art (with perhaps a few exceptions) is practiced with the...

Bus soc...

According to the textbook, the current world economy is increasingly becoming integrated and interdependent; as a result, the relationship between bu...

Management of patient information is a very import...

Information Technology in Health care (***** 409 words + APA Format + References *****)Write 400–600 words that respond to the following questions w...

Acc 205 week 5 final paper...

  Ashford 6: – Week 5 – Final Paper Final Paper  Focus of the Final Paper Write a five-to seven-page financial statement analysis of a public...

Liberty university educ 606 quiz 5...

 Liberty University EDUC 606 Quiz 5EDUC 606 Quiz 5·         Question 13 out of 3 pointsThe score that is duplicated (repeated) the largest n...

Math 533 final exam...

MATH533 – Final Exam Worksheet1.Given the following sample of 10 high temperatures from March: 55, 60, 57, 43, 59, 66, 72, 65, 59, 47.1.Determine th...

Biological criminal behavior paper/dr.martins m...

 PlEASE CHOOSE ONLY ONE OFFENDER  TO DO PAPER ON/ PLEASE DO APA, INSTRUCTOR WILL BE CHECKING FOR APA.  NEED AT LEAST 2 REFERENCES.Choose a crimina...

Annotated bibliography...

 focus on learning how to use APA method for documenting sources. Your major assignment is an Annotated Bibliography. APA Title PagePage 2 – APA H...

M8d1 history...

 This discussion addresses the following outcome:Ronald Reagan, as an individual and in his posthumous legacy, has been one of the most important fig...

Trend and issues in today health care...

Nurses often become motivated to change aspects within the larger health care system based on their real-world experience. As such, many nurses take o...

Week 6 - final assignment...

Psychological assessment guides are created by psychology professionals to provide the public with accurate and authoritative information appropriate...

Healthcare administration budgeting and financing...

Analysis Discussion—Financial CrisisOrganizations can experience crises due to changes in economic conditions. In an economic downturn where individ...

Introduction to philosophy...

 The Artichoke Version of the SelfWrite a 2–3-page paper explaining the artichoke idea of the self. Remember to explain specific theories with supp...

assignment of warranty and bond...

  1. FASB Code Questions :Pleasant Co. manufactures specialty bike accessories. The company is known for product quality, and it has offered one of...

school essay...

Hispanic-American Essay  youStudents will write an essay (100-300 words) answering the essay prompt: Write about a famous Hispanic-American chef that...

The Salem Witch Trials...

Please watch all 5 parts of the documentary. (approx 45mins)Salem Witch Trials:Part 01: http://www.youtube.com/watch?v=rkArW4qgc1Y&list=PLE9A6654DF36D...

Discussion: Gender Identity in Life-Span Developme...

 Gender identity—identifying oneself as male or female—is a critical component of an individual's life-span development. Misconceptions and s...

Interpersonal Communication at Your Workplace...

 Assignment 2: Interpersonal Communication at Your WorkplaceFor this assignment, you have the opportunity to apply what you have learned from the ass...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it