Please answer all questions.

NOTE: INCOME STATEMENT FOR YEAR 2012 AND 2013 ON LINE "INCOME (LOSS) FROM OPERATIONS" IS REPEATED PLEASE IGNORE REPEATED LINE.

2011 BALANCE SHEET

2011 INCOME STATEMENT

2011 STATEMENT OF CASH FLOWS

TRIAL BALANCE

Company A is considering a significant equipment replacement. Connie and Marie believe that the best time for this equipment replacement is at the end of 2013. However, they are concerned about the effects this replacement might have on their financial statements. The equipment originally cost 5440,000 and after depreciation expense is recorded in 2013, the equipment's accumulated depreciation balance will be 5390,000. At this point the equipment will be fully depreciated to its salvage value. Connie, Marie, Karla, and Laura tell you that they have thought of four options regarding the replacement of the old equipment. They could construct the new equipment themselves and then sell the old equipment, exchange the old equipment for new equipment that is more efficient, purchase new equipment and sell the old equipment, or overhaul the old equipment. When you heard this, you wondered about the current employees and whether acquiring new equipment will result in shifting jobs within the business and possibly lead to some layoffs. Because you are not sure how Connie and Marie will react to this concern, you decide not to bring up the subject at this time. Connie and Marie appear increasingly confident in your analysis skills, and they have asked you to determine the effects of the above alternatives for replacing or upgrading this equipment. Karla and Laura have gathered the following information to help with this analysis. Construct the new equipment in-house and sell the old equipment for cash at a fair value of 560,000. Company A would take out a one-year construction loan for 5350,000 at the beginning of 2013 at a short-term borrowing rate of 10% for the construction. Company A's present debt composition is as follows: a 5200,000 note at a 9% rate, a 5308,500 note at a 8% rate. Anticipated actual expenditures for constructing the equipment are 5650,000, and on a weighted-average basis the expenditures are approximately 5425,000. The bulk of the 5650,000 will be financed with the construction loan, and the balance will be financed through accounts payable. The interest on the short-term note is due and payable by year-end. (Note: Construction is assumed to be completed at year-end.) Purchase the new equipment by giving a non-interest-bearing note with five payments of 5164,000 to the supplier (starting on the first day of note's term and each year thereafter) and selling the old equipment for 560,000 cash. The first 5164,000 payment would be made in late December 2013. The prevailing interest rate for obligations of this nature is 10%. Overhaul the existing equipment. The following expenses are anticipated under this approach: JM normal annual cost for lubrication and replacement of minor parts to maintain the integrity of the exterior body would be 527,000. The cost of re-wiring interior components in an overhaul would be 5125,000. Replacing old worn components would cost 582,000 with associated labor costs of 5210,000 for installation. The overhaul is estimated to extend the useful life of the equipment another four years. (The present equipment's original useful life was eight years, starting January 1, 2006.) The costs will be financed at the end of 2013 through a one-year loan for 5350,000 at 10%, and the balance will be charged on account. For each of the four options presented, prepare journal proper form in the proposed adjustments columns on the trial balance. This will require four separate spreadsheet files for the four options. For any loans created, record the current portion to the accounts payable line on the trial balance, and change the description to accounts payable and short-term debt (both on the trial balance and on the balance sheet). Record any long-term portion to long-term liabilities. Write a brief memo on how each option affects the financial statements. Include your journal entry(jes) in the body of your memo for each option. Discuss the strengths and weaknesses of each option. since you are now in the process of analyzing the quantitative effects of this decision, you decide to also consider whether the acquisition of any new equipment will cause any employees to lose jobs. Also you wonder if there are other non-financial and/or ethical considerations you should include in your analysis. Write a memo describing other qualitative or subjective issues that you think Connie and Marie should consider in their analysis