Please solve the question if you are completely sure about the solution( with all steps in excel) also its all part of the same question so solve completely, otherwise I will downvote it.

Thanks.

Boyd Company has a line of credit with State Bank. Boyd can borrow up to $490,000 at any time over the course of the Year 1 calendar year. The following table shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during Year 1 . Boyd agreed to pay interest at an annual rate equal to 1 percent above the bank's prime rate. Funds are borrowed or repaid on the first day of each month. Interest is payable in cash on the last day of the month. The interest rate is applied to the outstanding monthly balance. For example, Boyd pays 5 percent ( 4 percent +1 percent) annual interest on $66,000 for the month of January. Boyd earned $34,000 of cash revenue during Year 1. Required Prepare an income statement, balance sheet, and statement of cash flows for Year 1. Complete this question by entering your answers in the tabs below. Prepare a balance sheet for Year 1. (Do not round intermediate calculations.) Prepare a statement of cash flows for Year 1. (Do not round intermediate calculations. Enter cash outflows with a minus sign.)