Create a Excel Sheet with formulas that calculates the following.

You are creating a budget for a single, 22-year-old recent finance graduate living in Augusta, GA. Chester (his friends and family call him Chet) has recently accepted a position with Southern Capital Group at a starting salary of $52.000. Chet is in good health and appreciates the importance of living within his means through a carefully designed budget. Through your conversations with Chet, you have accumulated the following facts. 1. First year annual bonuses average 4% of base salaries for first year employees. 2. Outstanding student loan balance: $25,000 at 4.0%. Chet wants to pay off the loan in 6 years. 3. Chet's employer has established a generous 401(K) plan and matches employee contributions dollar-for-dollar up to 6% of the employee's base salary. Employees are required to contribute a minimum of 4% and a maximum of 6%. 4. A high-deductible health plan will cost $100 per month. 5. Chet will be required to travel and needs to purchase a reliable car that befits the new career. It doesn't have to be new but should be suitable for taking clients to dinner. Think 4-door, conservative in the $20-25K range (tax and title, included). Her current car has a trade-in value of $5,000. (Chet has a clean driving record, but you should consider the insurance implications.) 6. The new position will require an update, professional wardrobe. The firm provides new employees with a $1,200 clothing allowance 20 days before starting with the firm (consider the tax consequences) to assist with this ongoing expense. You are creating a budget for a single, 22-year-old recent finance graduate living in Augusta, GA. Chester (his friends and family call him Chet) has recently accepted a position with Southern Capital Group at a starting salary of $52.000. Chet is in good health and appreciates the importance of living within his means through a carefully designed budget. Through your conversations with Chet, you have accumulated the following facts. 1. First year annual bonuses average 4% of base salaries for first year employees. 2. Outstanding student loan balance: $25,000 at 4.0%. Chet wants to pay off the loan in 6 years. 3. Chet's employer has established a generous 401(K) plan and matches employee contributions dollar-for-dollar up to 6% of the employee's base salary. Employees are required to contribute a minimum of 4% and a maximum of 6%. 4. A high-deductible health plan will cost $100 per month. 5. Chet will be required to travel and needs to purchase a reliable car that befits the new career. It doesn't have to be new but should be suitable for taking clients to dinner. Think 4-door, conservative in the $20-25K range (tax and title, included). Her current car has a trade-in value of $5,000. (Chet has a clean driving record, but you should consider the insurance implications.) 6. The new position will require an update, professional wardrobe. The firm provides new employees with a $1,200 clothing allowance 20 days before starting with the firm (consider the tax consequences) to assist with this ongoing expense