I need this project done by today midnight. I would really appreciate if you can do that. Thank you.

Account No. Account Location Code Location 100 Cash on hand 100 Dallas 100 Cash on hand 200 Atlanta 100 Cash on hand 300 LA 101 Cash - Operating 0 Corporate 101 Cash - Operating 100 Dallas 101 Cash - Operating 200 Atlanta 101 Cash - Operating 300 LA 102 Cash - Sweep 0 Corporate 103 Cash - Deposits 0 Corporate 110 Short term investment securities 0 Corporate 120 Accounts receivable 100 Dallas 120 Accounts receivable 200 Atlanta 120 Accounts receivable 300 LA 125 Allowance for doubtful accounts 100 Dallas 125 Allowance for doubtful accounts 200 Atlanta 125 Allowance for doubtful accounts 300 LA 130 Stock, Bonds, Mutual Funds 0 Corporate 140 Inventory 0 Corporate 140 Inventory 100 Dallas 140 Inventory 200 Atlanta 140 Inventory 300 LA 150 Notes receivable 0 Corporate 160 Prepaid insurance 0 Corporate 165 Prepaid other expenses 0 Corporate 165 Prepaid other expenses 100 Dallas 165 Prepaid other expenses 200 Atlanta 165 Prepaid other expenses 300 LA 170 Other current assets 0 Corporate 200 Long-term Investment securities 0 Corporate 210 Vehicles 0 Corporate 210 Vehicles 100 Dallas 210 Vehicles 200 Atlanta 210 Vehicles 300 LA 211 Accumulated depreciation - vehicles 0 Corporate 212 Furniture and fixtures 0 Corporate 212 Furniture and fixtures 100 Dallas 212 Furniture and fixtures 200 Atlanta 212 Furniture and fixtures 300 LA 213 Accumulated depreciation - furniture and fixtur 0 Corporate 214 Equipment 0 Corporate 214 Equipment 214 Equipment 214 Equipment 215 Accumulated depreciation - equipment 216 Buildings and Improvements 216 Buildings and Improvements 216 Buildings and Improvements 216 Buildings and Improvements 217 Accumulated depreciation - buildings and imp 218 Land 220 Goodwill 225 Other intangible assets 226 Accumulated amortization - intangible assets 300 Accounts payable 300 Accounts payable 300 Accounts payable 300 Accounts payable 310 Accrued interest expense 320 Withholding taxes payable 320 Withholding taxes payable 320 Withholding taxes payable 320 Withholding taxes payable 330 Accrued wages 330 Accrued wages 330 Accrued wages 330 Accrued wages 340 Unearned revenue 350 Accrued income taxes 360 Deferred tax liability 370 Short-term bank loan payable 375 Mortagage payable 380 Current Portion of Long-Term Debt 380 Current Portion of Long-Term Debt 380 Current Portion of Long-Term Debt 385 Long-Term Debt 385 Long-Term Debt 385 Long-Term Debt 390 Short-term notes payable 395 Long-term notes payable 400 Common stock 410 Additional paid-in capital 100 Dallas 200 Atlanta 300 LA 0 Corporate 0 Corporate 100 Dallas 200 Atlanta 300 LA 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 100 Dallas 200 Atlanta 300 LA 0 Corporate 0 Corporate 100 Dallas 200 Atlanta 300 LA 0 Corporate 100 Dallas 200 Atlanta 300 LA 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 100 Dallas 200 Atlanta 0 Corporate 100 Dallas 200 Atlanta 0 Corporate 0 Corporate 0 Corporate 0 Corporate 450 Retained earnings 470 Treasury Stock 500 Sales 500 Sales 500 Sales 500 Sales 505 Sales returns and allowances 505 Sales returns and allowances 505 Sales returns and allowances 505 Sales returns and allowances 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 605 Discount received 610 Purchase returns and allowances 700 Advertising Expense 710 Bad debt expense 720 Bank charges 730 Commissions expense 735 Contract labor 740 Delivery expense 745 Postage expense 750 Dues and subscriptions 760 Entertainment expense 770 Insurance expense 775 Rent expense 780 Office expense 785 Repairs expense 790 Payroll Expenses 795 Payroll taxes expense 800 Depreciation Expense 810 Amortization Expense 820 Interest expense 900 Investment income 910 Rental income 920 Interest received 930 Gain (loss) on sale of assets 950 Income taxes expense 0 Corporate 0 Corporate 0 Corporate 100 Dallas 200 Atlanta 300 LA 0 Corporate 100 Dallas 200 Atlanta 300 LA 0 Corporate 100 Dallas 200 Atlanta 300 LA 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate 0 Corporate G/L Account FS Account 100 Cash on hand 100 Cash and Cash Equivalents 100 Cash on hand 100 Cash and Cash Equivalents 100 Cash on hand 100 Cash and Cash Equivalents 101 Cash - Operating 100 Cash and Cash Equivalents 101 Cash - Operating 100 Cash and Cash Equivalents 101 Cash - Operating 100 Cash and Cash Equivalents 101 Cash - Operating 100 Cash and Cash Equivalents 102 Cash - Sweep 100 Cash and Cash Equivalents 103 Cash - Deposits 100 Cash and Cash Equivalents 110 Short term investment securities 100 Cash and Cash Equivalents 120 Accounts receivable 120 Account Receivables, net 120 Accounts receivable 120 Account Receivables, net 120 Accounts receivable 120 Account Receivables, net 125 Allowance for doubtful accounts 120 Account Receivables, net 125 Allowance for doubtful accounts 120 Account Receivables, net 125 Allowance for doubtful accounts 120 Account Receivables, net 130 Stock, Bonds, Mutual Funds 130 Investments 140 Inventory 140 Inventory, net 140 Inventory 140 Inventory, net 140 Inventory 140 Inventory, net 140 Inventory 140 Inventory, net 150 Notes receivable 150 Notes Receivable 160 Prepaid insurance 160 Prepaid Expenses 165 Prepaid other expenses 160 Prepaid Expenses 165 Prepaid other expenses 160 Prepaid Expenses 165 Prepaid other expenses 160 Prepaid Expenses 165 Prepaid other expenses 160 Prepaid Expenses 170 Other current assets 170 Other Current Assets 200 Long-term Investment securities 200 Investments 210 Vehicles 210 Property, Plant, and Equipment 210 Vehicles 210 Property, Plant, and Equipment 210 Vehicles 210 Property, Plant, and Equipment 210 Vehicles 210 Property, Plant, and Equipment 211 Accumulated depreciation - vehicles 220 Accumulated Depreciation 212 Furniture and fixtures 210 Property, Plant, and Equipment 212 Furniture and fixtures 210 Property, Plant, and Equipment 212 Furniture and fixtures 210 Property, Plant, and Equipment 212 Furniture and fixtures 210 Property, Plant, and Equipment 213 Accumulated depreciation - furniture and fi220 Accumulated Depreciation 214 Equipment 210 Property, Plant, and Equipment 214 Equipment 210 Property, Plant, and Equipment 214 Equipment 210 Property, Plant, and Equipment 214 Equipment 210 Property, Plant, and Equipment 215 Accumulated depreciation - equipment 220 Accumulated Depreciation 216 Buildings and Improvements 210 Property, Plant, and Equipment 216 Buildings and Improvements 210 Property, Plant, and Equipment 216 Buildings and Improvements 210 Property, Plant, and Equipment 216 Buildings and Improvements 210 Property, Plant, and Equipment 217 Accumulated depreciation - buildings and 220 Accumulated Depreciation 218 Land 210 Property, Plant, and Equipment 220 Goodwill 230 Goodwill 225 Other intangible assets 240 Intangibles, net 226 Accumulated amortization - intangible asse240 Intangibles, net 300 Accounts payable 300 Accounts Payable 300 Accounts payable 300 Accounts Payable 300 Accounts payable 300 Accounts Payable 300 Accounts payable 300 Accounts Payable 310 Accrued interest expense 310 Accrued Expenses 320 Withholding taxes payable 310 Accrued Expenses 320 Withholding taxes payable 310 Accrued Expenses 320 Withholding taxes payable 310 Accrued Expenses 320 Withholding taxes payable 310 Accrued Expenses 330 Accrued wages 310 Accrued Expenses 330 Accrued wages 310 Accrued Expenses 330 Accrued wages 310 Accrued Expenses 330 Accrued wages 310 Accrued Expenses 340 Unearned revenue 310 Accrued Expenses 350 Accrued income taxes 310 Accrued Expenses 360 Deferred tax liability 320 Deferred Tax Liability 370 Short-term bank loan payable 330 Loan Payable 375 Mortagage payable 360 Long-Term Debt 380 Current Portion of Long-Term Debt 340 Current Portion of Long-Term 380 Current Portion of Long-Term Debt 340 Current Portion of Long-Term 380 Current Portion of Long-Term Debt 340 Current Portion of Long-Term 385 Long-Term Debt 360 Long-Term Debt 385 Long-Term Debt 360 Long-Term Debt 385 Long-Term Debt 360 Long-Term Debt 390 Short-term notes payable 350 Current Portion of Notes Payab 395 Long-term notes payable 370 Notes Payable 400 Common stock 400 Common Stock 410 Additional paid-in capital 410 Additional Paid-In Capital 450 Retained earnings 470 Treasury Stock 500 Sales 500 Sales 500 Sales 500 Sales 505 Sales returns and allowances 505 Sales returns and allowances 505 Sales returns and allowances 505 Sales returns and allowances 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 605 Discount received 610 Purchase returns and allowances 700 Advertising Expense 710 Bad debt expense 720 Bank charges 730 Commissions expense 735 Contract labor 740 Delivery expense 745 Postage expense 750 Dues and subscriptions 760 Entertainment expense 770 Insurance expense 775 Rent expense 780 Office expense 785 Repairs expense 790 Payroll Expenses 795 Payroll taxes expense 800 Depreciation Expense 810 Amortization Expense 820 Interest expense 900 Investment income 910 Rental income 920 Interest received 930 Gain (loss) on sale of assets 950 Income taxes expense 450 Retained Earnings 470 Treasury Stock 500 Net Sales 500 Net Sales 500 Net Sales 500 Net Sales 500 Net Sales 500 Net Sales 500 Net Sales 500 Net Sales 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 600 Cost of Goods Sold 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 700 Selling, General, and Administr 800 Depreciation and Amortization 800 Depreciation and Amortization 810 Interest Expense 900 Interest and Investment Incom 910 Other income 900 Interest and Investment Incom 910 Other income 950 Provision for Income Taxes FS SubGroup 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 1 Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets FS Group 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 2 Non-Current Assets 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 2 Non-Current Liabilities 1 Current Liabilities 1 Current Liabilities 1 Current Liabilities 2 Non-Current Liabilities 2 Non-Current Liabilities 2 Non-Current Liabilities 1 Current Liabilities 2 Non-Current Liabilities 3 Stockholders' Equity 3 Stockholders' Equity 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 1 Assets 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 2 Liabilities and Stockholder's Equi 3 Stockholders' Equity 2 Liabilities and Stockholder's Equi 3 Stockholders' Equity 2 Liabilities and Stockholder's Equi 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 5 Net Sales 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 6 Cost of Goods Sold 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 7 Selling, General, and Administrat7 Operating Expenses 8 Depreciation and Amortization 7 Operating Expenses 8 Depreciation and Amortization 7 Operating Expenses 81 Interest Expense 8 Interest and Other (Income) Expe 9 Interest and Investment Income 8 Interest and Other (Income) Expe 91 Other income 8 Interest and Other (Income) Expe 9 Interest and Investment Income 8 Interest and Other (Income) Expe 91 Other income 8 Interest and Other (Income) Expe 95 Provision for Income Taxes 9 Provision for Income Taxes FS Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet 2016 8,800 17,600 3,300 33,236,500 127,600 257,400 92,400 110,000 4,209,700 2,310,000 20,170,700 39,905,800 4,269,100 (896,500) (1,987,700) (114,400) 51,245,700 29,462,400 2,020,700 6,839,800 958,100 6,909,100 948,200 1,773,200 167,200 223,300 19,800 14,681,700 42,735,000 9,208,100 204,600 380,600 68,200 (6,191,900) 16,420,800 705,100 1,141,800 360,800 (9,469,900) 110,110,000 2015 9,900 19,800 1,100 31,619,500 118,800 277,200 106,700 198,000 3,952,300 2,106,500 16,309,700 34,751,200 4,320,800 (674,300) (2,105,400) (129,800) 46,948,000 31,295,000 2,520,100 8,285,200 969,100 6,487,800 929,500 1,614,800 194,700 250,800 24,200 13,735,700 41,123,500 9,026,600 ### 332,200 ### (6,020,300) 16,528,600 683,100 953,700 352,000 (9,509,500) 101,345,200 2014 6,600 15,400 2,200 29,569,100 107,800 265,100 96,800 110,000 2,839,100 1,870,000 14,329,700 31,775,700 4,039,200 (574,200) (1,850,200) (95,700) 43,045,200 28,458,100 2,220,900 7,603,200 870,100 7,023,500 919,600 1,563,100 200,200 221,100 15,400 9,208,100 37,209,700 8,923,200 204,600 ### 68,200 (5,838,800) 16,303,100 668,800 943,800 356,400 (9,429,200) 93,737,600 Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet 167,200 217,800 62,700 (82,390,000) 93,720,000 5,401,000 5,830,000 2,002,000 (19,052,000) 40,744,000 14,345,100 12,520,200 (2,346,300) (58,327,500) (2,086,700) (3,410,000) (689,700) (6,875,000) (10,719,500) (389,400) (691,900) (90,200) (4,438,500) (198,000) (2,530,000) (44,000) (4,831,200) (4,263,600) (17,009,300) (4,510,000) (4,675,000) (3,080,000) (550,000) (825,000) (17,600,000) (2,750,000) (4,675,000) (5,500,000) (55,000,000) (5,500,000) (71,500,000) 158,400 226,600 58,300 (75,729,500) 102,752,100 ### ### ### (17,578,000) ### 6,807,900 11,966,900 (2,185,700) (56,820,500) (1,740,200) (4,387,900) (633,600) (6,655,000) (10,211,300) (374,000) (677,600) (86,900) (6,968,500) (187,000) (1,980,000) ### (5,650,700) (3,990,800) (15,447,300) (1,100,000) (4,840,000) (2,750,000) ### ### (20,240,000) (3,300,000) (5,500,000) ### ### ### ### 151,800 215,600 59,400 (71,409,800) 104,365,800 5,401,000 3,575,000 2,002,000 (15,660,700) 40,744,000 ### 8,999,100 (1,771,000) (57,295,700) (1,554,300) (3,098,700) (750,200) (8,525,000) (8,989,200) (364,100) (657,800) (82,500) (5,391,100) (171,600) (275,000) (44,000) (4,420,900) (3,320,900) (14,220,800) (1,210,000) (5,280,000) (1,650,000) (550,000) (825,000) (17,600,000) (3,850,000) (6,325,000) (5,500,000) (55,000,000) (5,500,000) (71,500,000) Balance Sheet Balance Sheet Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement Income Statement (163,854,900) 2,750,000 (86,963,800) (117,509,700) (325,509,800) (41,489,800) 90,200 129,800 359,700 80,300 62,137,900 80,696,000 227,033,400 29,712,100 (3,540,900) (947,100) 10,397,200 10,608,400 19,800 4,122,800 2,989,800 4,742,100 1,960,200 30,800 2,070,200 4,093,100 5,313,000 6,730,900 2,365,000 81,925,800 6,787,000 9,352,200 490,600 6,241,400 (4,231,700) (1,760,000) (1,188,000) 619,300 8,155,400 (149,968,500) ### (105,422,900) (110,298,100) (290,420,900) (35,109,800) 85,800 77,000 366,300 111,100 56,299,100 73,943,100 200,493,700 25,210,900 (3,285,700) (893,200) 14,822,500 10,260,800 24,200 3,872,000 2,105,400 4,629,900 1,789,700 28,600 2,103,200 3,868,700 5,009,400 6,579,100 2,299,000 80,284,600 7,621,900 9,237,800 ### 6,414,100 (2,989,800) ### (1,173,700) 495,000 12,475,100 (129,613,000) 2,750,000 (94,789,200) (90,983,200) (255,220,900) (33,133,100) 81,400 92,400 280,500 74,800 50,746,300 65,792,100 176,200,200 22,795,300 (2,597,100) (471,900) 16,798,100 9,583,200 17,600 3,412,200 2,009,700 3,649,800 1,690,700 20,900 2,900,700 3,631,100 2,009,700 6,298,600 2,780,800 71,431,800 6,620,900 8,020,100 490,600 5,678,200 (2,411,200) (1,760,000) (1,009,800) (211,200) 11,712,800 Intermediate Financial Accounting III - 4113 Fall 2016 Analytics and Critical Thinking Project PantherTec sponsors a defined benefit pension plan for its employees. The company's pension formula pays 2% per year of service time of the employee's final year's salary, with a maximum benefit of 60% of final salary. To illustrate, an employee earning $200,000 and retiring after 20 years would receive an $80,000 annual benefit (2% x 20 years x $200,000). Accompanying this project is an Excel spreadsheet with two tabs. The first, \"Employee Information,\" lists the 200 employees of PantherTec, along with information which may or may not be needed to compute pension obligations. The second tab, \"Pension Plan Asset Performance,\" outlines how PantherTec's plan assets have performed over the last several periods, expected returns on plan assets over that period, and information on previous amortizations. There are no prior service costs or other accumulated losses on the projected benefit obligation. Required: Write a project summary addressing each of the following requirements, citing accompanying tables and figures as necessary. Your final deliverable should include a typed report with responses to each of the following points as well as an Excel file with supporting analysis. Responses should be succinct, but complete. Analyses: 1. Compute the projected benefit obligation (PBO) as of 12/31/2014 using the \"Employee Information\" tab assuming the company's actuary recommends a 6% discount rate. For simplicity, assume that all retirements occur on December 31 of the retirement year, and partial years worked provide no benefit. In other words, if a 40 year-old employee begins working on 7/1/2014 and is expected to retire at 65, then assume that his retirement date is 12/31/2039 and that he will accrue 25 years of service (2015 through 2039). Computations should be performed in Excel. 2. Compute Pension Expense for 2014, separately identifying each component. Assume that no actuarial assumptions changed between 2013 and 2014 (i.e., same projected ending salaries, benefit periods, etc.). 3. Describe the funding status for the plan. Is the plan over- or under-funded? 4. PantherTec is considering a pension plan amendment that would alter its plan to pay an annual benefit of 2.75% instead of 2%. In addition, the company's actuary recently suggested that the company may need to reduce its discount rate from 6% to 5% in 2015 in light of historically low interest rates. Treating each potential change independently, compute the effect of the changes on the company's PBO as of 12/31/2014 and comment on how each would be recorded, should the changes be enacted. Critical Thinking: 5. Compare pension and salary information male vs. female employees. Comment on possible reasons for those differences. Can you infer anything about expectations for male vs. female employees from the data provided? It may be useful to use a Pivot Table for your analysis. 6. Assume PantherTec is considering investing in an employee health and wellbeing program. This program will involve an onsite fitness center and complementary dietary and fitness consulting services. Discuss how this program could affect pension costs. Can you assess whether these concerns appear to be valid (hint: consider using \"CORREL()\")? Keeping in mind that managers of companies have both social responsibilities to employees and fiduciary responsibilities to shareholders, what considerations should the manager take into account when making this decision? 7. Comment on the trend in plan asset returns. Have managers been accurate in their expected rates of return? When pension plan assets consistently deviate from expected returns, managers may either adjust the riskiness of the plan's investment portfolio, or adjust the expected rate of return. Discuss the ethical dilemma managers face when confronted with those two choices