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:
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:
From the above calculations, it is concluded that actual monthly expenses on housing have exceeded the projected cost by $12.
From the above calculations, it is concluded that actual monthly expenses on transportation have exceeded the projected cost by $36.
From the above calculations, it is concluded that actual monthly expenses on insurance is equal to the projected cost.
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:
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.
Now, calculate the difference between actual and projected income of the person, as follows:
If the person gets extra source of income for the same month, his savings would increase as shown below:
Calculation of Previous savings:
Savings after getting an extra income of $200:
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:
Organization dues or fees
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:
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) Similarly, calculate the total price of laptops, printers, scanners and software for other brands as shown below:
Company T has a total budget of $250,000. Calculate its total expenditures and savings as follows:
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