Create a pro forma post-graduation budget in Excel. Evaluate your budget and submit one Excel file that includes both the budget and evaluation. Estimate income that you will earn from your job after...

1 answer below »

Create a pro forma post-graduation budget in Excel. Evaluate your budget and submit one Excel file that includes both the budget and evaluation. Estimate income that you will earn from your job after graduation. Include five to ten expenses that you will incur (e.g., rent, student loan payments, cell phone, car payment, insurance, food, utilities).


In the evaluation (250-500 words), answer the following questions in complete sentences:



  • Am I living within my means? Does my income cover my expenses? Do I have enough income to pay my bills?

  • Am I financially independent from my family?

  • Do I have an emergency fund?

  • Am I saving enough for retirement in my budgets/planning?

  • Do I have enough to start giving financially to others?


While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.




Rubic_Print_Format Course CodeClass CodeAssignment TitleTotal Points FIN-350FIN-350-O500Personal Budget Project10.0 CriteriaPercentage1: Unsatisfactory (0.00%)2: Less Than Satisfactory (65.00%)3: Satisfactory (75.00%)4: Good (85.00%)5: Excellent (100.00%)CommentsPoints Earned Group 1100.0% Personal Budget35.0%Personal budget is not present.Personal budget includes less than four expenses. Pro forma budget is disorganized, and some Excel formulas are incorrect.Personal budget includes four or five mostly accurate expenses. Pro forma budget is organized and Excel formulas are mostly correct.Personal budget includes 5-10 accurate expenses. Pro forma budget is well organized and Excel formulas are correct.Personal budget includes 5-10 accurate expenses. Pro forma budget is thorough and well organized, and appropriate Excel formulas are correct and contain no errors. Evaluation35.0%Evaluation is not present.Evaluation of means, financial independence, emergency fund, budgets and planning, and giving is present but not developed, ideas are present but not developed or supported; evidence is lacking.Evaluation of means, financial independence, emergency fund, budgets and planning, and giving is sound and solid; ideas are present but not particularly well developed or supported; some evidence, but usually of a generalized nature, is provided.Evaluation of means, financial independence, emergency fund, budgets and planning, and giving is well-presented and argued; ideas are detailed, developed, and supported with mostly specific evidence and details.Evaluation of means, financial independence, emergency fund, budgets and planning, and giving is extremely well presented and argued; ideas are detailed, well developed, and supported with specific evidence and facts, as well as examples and specific details. Thesis Development and Purpose7.0%Paper lacks any discernible overall purpose or organizing claim.Thesis is insufficiently developed or vague. Purpose is not clear.Thesis is apparent and appropriate to purpose.Thesis is clear and forecasts the development of the paper. Thesis is descriptive and reflective of the arguments and appropriate to the purpose.Thesis is comprehensive and contains the essence of the paper. Thesis statement makes the purpose of the paper clear. Argument Logic and Construction8.0%Statement of purpose is not justified by the conclusion. The conclusion does not support the claim made. Argument is incoherent and uses noncredible sources.Sufficient justification of claims is lacking. Argument lacks consistent unity. There are obvious flaws in the logic. Some sources have questionable credibility.Argument is orderly but may have a few inconsistencies. The argument presents minimal justification of claims. Argument logically, but not thoroughly, supports the purpose. Sources used are credible. Introduction and conclusion bracket the thesis.Argument shows logical progression. Techniques of argumentation are evident. There is a smooth progression of claims from introduction to conclusion. Most sources are authoritative.Clear and convincing argument presents a persuasive claim in a distinctive and compelling manner. All sources are authoritative. Mechanics of Writing (includes spelling, punctuation, grammar, language use)5.0%Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used.Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied.Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed.Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech.Writer is clearly in command of standard, written, academic English. Paper Format (use of appropriate style for the major and assignment)10.0%Template is not used appropriately, or documentation format is rarely followed correctly.Appropriate template is used, but some elements are missing or mistaken. A lack of control with formatting is apparent.Appropriate template is used. Formatting is correct, although some minor errors may be present.Appropriate template is fully used. There are virtually no errors in formatting style.All format elements are correct. Total Weightage100%
Answered Same DayJun 21, 2021

Answer To: Create a pro forma post-graduation budget in Excel. Evaluate your budget and submit one Excel file...

Pranjal answered on Jun 25 2021
146 Votes
Sheet1
        Pro-forma Post-Graduation Budget:
        Post-Graduation Budget for 5 Years
        Particulars    Year 1    Y
ear 2    Year 3    Year 4    Year 5    Total
        Earning from Salary (A)    24,000    24,480    24,970    25,469    25,978    124,897
        Expenses:
        House Rent    6,000    6,060    6,121    6,182    6,244    30,606
        Food and Clothing    3,000    3,030    3,060    3,091    3,122    15,303
        Electricity    1,200    1,212    1,224    1,236    1,249    6,121
        Mobile Phone Bill Payment    1,200    1,212    1,224    1,236    1,249    6,121
        Credit Card Payment    3,000    3,030    3,060    3,091    3,122    15,303
        Insurance    1,200    1,200    1,200    1,200    1,200    6,000
        Student Loan Repayment    3,600    3,600    3,600    3,600    3,600    18,000
        Utilities    1,800    1,818    1,836    1,855    1,873    9,182
        Total Expenses (B)    21,000    21,162    21,326    21,491    21,658    106,636
        Net Savings (A-B)    3,000    3,318    3,644    3,978    4,321    18,261
        Growth Rate in Net Savings    NA    11%    10%    9%    9%    NA
        Evaluation:
        The budget shows that I have been able to live my means. My income covers my expenses and I have been able to accumulate surplus out of my income as well.
        Since I have been able to accumulate...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here