I am seeking assitance with this problem. Please format in excel or word.

Need assistance with the following problems 1) The following is selected information from Reliant Company for the fiscal years ended December 31, 2016: Reliant Company had net income of $1,225,000. Depreciation was $500,000, purchases of plant assets were $1,250,000, and disposals of plant assets for $500,000 resulted in a $50,000 gain. Stock was issued in exchange for an outstanding note payable of $725,000. Accounts receivable decreased by $25,000. Accounts payable decreased by $40,000. Dividends of $300,000 were paid to shareholders. Reliant Company had interest expense of $50,000. Cash balance on January 1, 2016 was $250,000. Requirements: Prepare Reliant Company's statement of cash flows for the year ended December 31, 2016 using the indirect method. 2 Rayco Corporation had the following bond transactions during the fiscal year 2016: a. On January 1: issued ten $1,000 bonds at 102. The 5-year bonds is dated January 1, 2016. The contract interest rate is 6%. Straight-line amortization method is used. Interest is payable semi-annual on January 1 and July 1. b. On July 1: Rayco Corporation issued $500,000 of 10%, 10-year bonds. The bonds dated January 1, 2016 were issued at 88.5, and pay interest on July 1 and January 1. Effective interest rate for these bonds is 12%. Straight-line amortization method is used. c. On October 1: issued 10-year bonds $10,000 face value bonds, for $10,853 cash. The bonds have a stated rate of 9%, but an effective rate of 6%. Straight-line amortization method is used. Interest is payable on October 1 and April 1. Requirements: Prepare all general journal entries for the three bonds issued and any interest accruals and payments for the fiscal year 2016. (Round all calculations to nearest whole dollar.) 3) XYZ had sales of $10,000 (100 units at $100 per). Manufacturing costs consisted of direct labor $1,500, direct materials $1,400, variable factory overhead $1,000, and fixed factory overhead $500. The company did not maintain any inventories, so total cost of goods sold was $4,400. Selling expenses totaled $1,600 ($600 variable and $1,000 fixed), and administrative expenses totaled $1,500 ($500 variable and $1,000 fixed). Operating income was $2,500. Round all final answers to nearest dollar or whole number. Requirements: a. What is the break-even point in sales dollars and in units if the fixed factory overhead increased by $1,700? b. What is the break-even point in sales dollars and in units if costs remain as originally projected? c. What would be the operating income if sales units increased by 25%? 4) XYZ manufactures tote bags. The forecasted income statement for the year before any special orders included sales of $4,000,000 (sales price is $10 per unit.) Manufacturing cost of goods sold is anticipated to be $3,200,000. Selling expenses are expected to be $300,000, and operating income is projected at $500,000. Fixed costs included in these forecasted amounts are $1,200,000 for manufacturing cost of goods sold and $100,000 for selling expenses. Rayco is offering a special order to buy 50,000 tote bags for $7.50 each. There will be no additional selling expenses, and sufficient capacity exists to manufacture the extra tote bags. Requirements: Prepare an incremental analysis schedule to demonstrate what amount operating income would increase or decrease as a result of accepting the special order. 5) RSW Company manufactures 10,000 units of wheel sets for use in its annual production. Costs are as follows: direct materials are $20,000; direct labor is $55,000; variable overhead is $45,000; and fixed overhead is $70,000. Rayco Company has offered to sell RSW 10,000 units of wheel sets for $18 per unit. If RSW accepts the offer, some of the facilities presently used to manufacture wheel sets could be rented to a third party at an annual rental of $15,000. Additionally, $4 per unit of the fixed overhead applied to wheel sets would be totally eliminated. Requirements: Prepare an incremental analysis schedule to demonstrate if RSW should accept Rayco's offer