Appendix

Business

Create a monthly budget template for a person in excel sheet including his projected and actual income and expenditures as shown below: Calculate total projected and actual monthly income of the person as shown below: img From the above calculations, it can be concluded that projected monthly income of the person exceeds his actual income by $300. Calculate total projected and actual monthly expenditure of the person as shown below: Housing expenses: img From the above calculations, it is concluded that actual monthly expenses on housing have exceeded the projected cost by $12. Transportation Cost: img From the above calculations, it is concluded that actual monthly expenses on transportation have exceeded the projected cost by $36. Insurance cost: img From the above calculations, it is concluded that actual monthly expenses on insurance is equal to the projected cost. Food cost: img From the above calculations, it is concluded that actual monthly expenses on food is less than the projected cost by $5. Similarly calculate the expenditure on pets, personal care, and entertainment products as shown below: img From the above calculations, it is concluded that actual monthly expenses on pets and entertainment meets the projected cost. However, actual expenses on entertainment are less than the projected cost by $37. Total projected and actual expenses of the person can be calculated by adding his different expenditures on housing, transportation, insurance, food, pets, entertainment and personal care. img Now, calculate the difference between actual and projected income of the person, as follows: img If the person gets extra source of income for the same month, his savings would increase as shown below: Calculation of Previous savings: img Savings after getting an extra income of $200: img Hence, it can be concluded that savings of the person would increase by $200 after getting an additional source of income. Now, prepare a 10 years budget for the same person after he gets a job and have his spouse and children. This budget would include few additional sources of income and expenditures. Those cells are highlighted in the below template: img img Hair/nails   Clothing   Dry cleaning   Health club   Organization dues or fees   Other   Subtotals       img img Income of the person would increase after getting a job. His expenditures would also increase after getting married and having children. The person would pay loans, taxes and credit bills. Besides this, he would require savings and investments.

Cash flow statement is the financial statement of a company that represents total income and expenditures for a specific period. Hence, it would help to determine the savings of a company for a certain period of time. Cash flow statement of Firm G is given below: img From the above calculations, it can be concluded that Firm G would be able to save an amount of $26,211 at the month end.

Company T is going to hire six new employees in next month. Therefore, they would require purchasing six laptops, a scanner, three colour printers and business software. Total budget allocated for this purpose is $250,000. Prepare an excel sheet to compare the prices of different products offered by Apple, Dell and HP, as shown below: (Here, least expensive products are taken for each brand; company can increase its expenditure on various products as per their requirement) img Similarly, calculate the total price of laptops, printers, scanners and software for other brands as shown below: img Company T has a total budget of $250,000. Calculate its total expenditures and savings as follows: img From the above calculations, it is clear that the company can save maximum amount of money by purchasing products of Hewlett Packard.

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question

There is no answer for this question