I need help with my Accounting homework! I'm a little confused about the whole thing.

ACC 3010 Project 3 Winter 2016 DUE April 23, 2016- This project is due on April 23 before 8:00 pm. Additional hours for help with the project will be posted on the class Blackboard site. Your file must be named - "Your name (first and last) your TAs last name project 3" so that the TAs can do the initial grading. Failure to name the file correctly will result in a deduction in points. This project is a continuation of Projects 1 & 2, FMoore Consulting and Sales Inc. A time machine has taken us 2 years into the future and you have been asked to make some recommendations to the company regarding financing for an upcoming major expansion. The company has been very successful but they will need a major inflow of cash to purchase the fixed assets they need for the expansion and hire additional employees. They believe they will need at least $3,000,000 and have asked for your recommendations as to how they should obtain the necessary funds. They have provided information about their available financing options and have asked you to evaluate them and make a recommendation as to which option they should pursue. They have also asked for depreciation schedules for the new assets they plan to purchase. Finally they have asked for information about the cash inflows they can expect from each of the financing options and the expected annual cash outflow required for each financing option. They also request a calculation of several ratios under each of the financing alternatives. When you need information about Assets for any of the ratio calculations, remember that Assets = Liabilities + Equity. Also, assume the split between Current Assets and Long Term Assets is 10% current and 90% long term. The included post closing trial balance represents the year end information for October 31, 2018. (The company's fiscal year is from November 1 to October 31). You have been asked to consider the company's financing options and provide the company with a 2-3 paragraph recommendation as to which opportunity they should pursue. (a blank sample memo format is posted on the class Blackboard site under the Projects button with the 3rd project information) The information about the various financing opportunities available is provided in this project information. You are also provided information regarding the plant asset purchases the company plans with the cash inflows. The following is a suggested series of steps for completing the project: Complete the attached Depreciation Schedules for each of the planned asset purchases using the provided information regarding cost, useful life, and selected method. You should do only the first 4 years for the building and do the complete useful life depreciation schedules for all of the other assets. Complete the worksheet for the various financing options using the information provided remembering that you must show your work on the worksheet not just as a formula used to compute the numbers on the worksheet. You must show how you arrived at the numbers in the body of the worksheet. Complete the 3 \"partial classified balance sheets\". These should include ONLY the Liabilities and Equities sections of the classified balance sheet. These must have all proper formatting but do NOT need to have headings. They should be labeled to indicate which financing option it represents. Complete the Ratio Calculation worksheet . You are computing the ratios listed for each of the 3 financing considerations listed. You should show your work for potential full credit. Remember Assets = Liabilities + Equity. Also Current Assets is 10% of total assets. Complete the memo with your recommendation to the company as to which financing option they should pursue and why you feel that is the appropriate option. In your recommendation please explain in words which option you are recommending. Do not just refer to the number of the option. This MUST be typed in Word and be in proper memo format . Your memo will be graded on grammar, structure, spelling, etc. as well as how you justify which option you choose to recommend to the company. To be considered for full credit for the memo you will need to include at least 3 different (unique) reasons for why you recommend a particular financing option. The TAs, Sandee, and I will not provide guidance on information related to your memo. The TAs, Sandee, and I also will not proofread your memo before its submission. You MUST prepare the memo on your own based on what you have read and what you know. The Word Document must be named the same as your excel file - Your Name and your TA's last name. Failure to do so will result in a deduction of points. REQUIRED TO TURN IN: Your memo (prepared in Word) to the final memo submission Your excel file to the final excel submission INCENTIVE POINTS FOR PROJECT 3 - to earn the incentive points you must submit your excel file with the items indicated below completed and correct. April 6 by 9pm Incentive Point - You must submit your excel file with the Depreciation tables completed. You can receive an additional incentive point if you use primarily formulas to complete the depreciation tables. April 13 by 9pm Incentive Point - You must submit your excel file with the financing options worksheet and the partial balance sheets for the first 2 financing options completed FMoore Consulting and Sales Inc Post Closing Trial Balance October 31, 2018 Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Inventory Prepaid Insurance Land Building Accumulated Depr - Building Office Equipment Accumulated Depr - Office Equip Computer Equipment Accumulated Depr - Computer Equip Accounts Payable Utilities Payable Wages Payable Interest Payable Long term Note Payable Mortgage Payable Common Stock ($1 par, 1,000,000, shares authorized, 400,000 issued and outstanding) Retained Earnings $ 204,900 76,580 $ 5,690 56,500 68,596 57,890 260,000 550,000 25,650 856,850 22,500 556,500 10,250 25,620 16,850 32,560 25,000 290,000 306,800 400,000 1,526,896 $ 2,687,816 $ 2,687,816 PLANNED ASSET ACQUISITIONS Reminder that the company's fiscal year is November 1 through October 31. Asset Land Building Office Equipment Assembly Equipment Delivery Equipment Cost Useful life Salvage Depreciation Purchase Date Value Method N/A N/A 1-Nov-18 15,500 Straight line 1-Nov-18 10,500 Straight line 1-Jan-19 250,000 625,000 460,500 N/A 20 4 585,000 5 25,000 production 1-May-19 360,000 4 40,000 production 1-Aug-19 2,280,500 Additional information related to the $585,000 assembly equipment purchase: It is ESTIMATED that the equipment will be ABLE TO ASSEMBLE 280,000 total units over its lifetime. To complete the depreciation schedule, PRESUME that the actual units assembled for its useful life are as indicated below. Also, round depreciation expense per unit to the nearest cent and depreciation expense to the nearest dollar. Year 1 Year 2 Year 3 Year 4 Year 5 52500 59650 56850 54650 59750 Additional information related to the $360,000 delivery equipment purchase: It is ESTIMATED that the equipment will be ABLE TO DRIVE 200,000 total miles over its lifetime. To complete the depreciation schedule, PRESUME that the actual miles driven for its useful life are as indicated below. Also, round depreciation expense per unit to the nearest cent and depreciation expense to the nearest dollar. Year 1 Year 2 Year 3 Year 4 35,950 53,520 58,950 58,950 Building Depreciation Schedule Depreciation for the Year Date Asset Cost Dep'ble basis Rate Depreciation Expense Accumulated Depreciation Book Value Office Equipment Depreciation Schedule Depreciation for the Year Date Asset Cost Dep'ble basis Rate Depreciation Expense Accumulated Depreciation Book Value Assembly Equipment Depreciation Schedule Depreciation for the Year Date Date Asset Cost Depreciation per unit Units of Production Depreciation Expense Accumulated Depreciation Book Value Asset Cost Delivery Equipment Depreciation Schedule Depreciation for the Year Depreciation per unit Units of Depreciation Accumulated Production Expense Depreciation Book Value FMoore Consulting and Sales Inc Cash Provided/Annual Year Cash Payment Requirement The company could issue $3,500,000 of long-term bonds, due in 4 years with a stated rate of interest, paid semiannually, of 6%. The market rate for similar debt is 8%. Cash Received Annual Cash Required The company could issue $3,000,000 of long-term bonds, due in 6 years with a stated rate of interest, paid semiannually, of 6%. The market rate for similar debt is 4%. Cash Received Annual Cash Required The company could issue 500,000 additional shares of $1 par value common stock for $7 per share The company will begin paying a dividend to all the common shareholders of $0.20 per share and this will continue into the future. Cash Received Annual Cash Required PARTIAL BALANCE SHEETS Financing 1 - $3,500,000 6% bonds due in 4 years Financing 2 - $3,000,000 6% bonds due in 6 years Financing 3 - 500,000 additional shares of $1 par common stock for $7 per share FMoore Consulting and Sales Inc Financial Ratios and Calculations Ratios Current Ratio Current Assets Current Liabilities Debt to Asset Ratio Total Debt Total Assets Debt to Equity Total Debt Total Equity Financing 1 $3,500,000 6% bonds due in 4 years Financing 2 $3,000,000 6% bonds due in 6 years Financing 3 500,000 additional shares of $1 par common stock for $7 per share