Hi I need help with this entire project, I do not understand it. I would greatly appreciate it. Thank you!

I have attached the project as well as the memo that needs to be done as well.

Memo To: From: Date: Re: ACC 3010 Project 3 Version 2 Fall 2016 DUE December 10, 2016- This project is due on December 10 before 8:00 pm. Additional hours for help with the proj will be posted on the class Blackboard site in the week proceeding the due date. Your file must be named - "Your nam (first and last) your TAs name project 3" so that the TAs can do the initial grading. Failure to name the file correctly wi result in a deduction in points. This project is a continuation of Projects 1 & 2, JaJos 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 $2,000,000 and have asked for you 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. T 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 e 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 15% current and 85% long term. The included post closing trial balance represents the year end information for May 31, 2018. (The company's fiscal year is fro June 1 to May 31). You have been asked to consider the company's financing options and provide the company with a 3-4 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 regar 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 yo work on the worksheet not just as a formula used to compute the numbers on the worksheet. You must show how you arrived 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 class 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 liste You should show your work for potential full credit. Remember Assets = Liabilities + Equity. Also Current Assets is 15% of tota assets. The projected Net Incomes for the year for the 3 alternatives are: Option 1 $356,650; Option 2 $368,560; and Option $457,650 Complete the memo with your recommendation to the company as to which financing option they should pursue and why you that is the appropriate option. In your recommendation please explain in words which option you are recommending. Do not ju 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 w you have read and what you know. The Word Document must be named the same as your excel file - Your Name and your TA name project 3. Failure to do so will result in a deduction of points. Your file must also generate a preview to be graded. Each student must submit an ORIGINALexcel file to the final project 3 assignment link in Blackboard and their memo to the memo submission link. While students are encouraged to work together, each student must process and format his/her own set of statements. Duplicate submissions (format, not numbers) wil result in the students receiving a 0 for the assignment. Just changing the font size or orientation/placemen not really an "original effort". REQUIRED TO BE SUBMITTED - You must submit your excel file and your memo file to the correct assignments links on the class Blackboard site by 8 pm Saturday December 10. Your file must be named - "Yo name (first and last) your TAs name project 3" so that the TAs can do the initial grading. Your project and memo must generate a preview to be graded. Submissions will NOT be accepted via email attachment. Submission to other than the correct link on BlackBoard will result in a 5 point deduction. NO LATE SUBMISSIONS WILL BE ACCEPTED. INCENTIVE POINTS FOR PROJECT 3 - to earn the incentive points, you must submit your whole excel file the appropriate assignment link on the class Blackboard site before 8 pm on the date indicated. Your submiss must be correct and your file must be named correctly and generate a preview to earn the incentive points. Incentive Point 1 - due November 23 You must submit your complete excel file with the Depreciation tables comple Incentive Point 2 - due November 30 You must submit your complete excel file with the financing options workshee the partial balance sheets completed. Incentive Point 3 - due December 10 with your final project submission. To earn these 3 incentive points you must h used formulas to complete the majority of your depreciation tables, your partial balance sheets, and your ratios. To s this, you must copy your depreciation tables tab information to the depreciation tables formulas tab, copy your partia balance sheets tab information to the partial balance sheets formulas tab and copy your ratios tab to the ratios formul tab. Then in the formulas tabs, you must highlight the entire depreciation tables, partial balance sheet, or ratios area press the "ctrl" key and the "~" key. This will cause the formulas to be displayed instead of the numbers. You must th save the file so the formulas are saved. JaJos Consulting and Sales Inc Post Closing Trial Balance May 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, 300,000 issued $ 204,900 76,580 $ 5,690 56,500 68,596 57,890 260,000 550,000 25,650 856,850 556,500 22,500 10,250 25,620 16,850 32,560 25,000 390,000 406,800 300,000 and outstanding) Retained Earnings 1,426,896 $ 2,687,816 $ 2,687,816 896,830 debt 1,726,896 equity PLANNED ASSET ACQUISITIONS Reminder that the company's fiscal year is June 1 through May 31. Asset Cost Useful life Land Building Office Equipment 250,000 525,500 250,500 N/A 30 5 Assembly Equipment 485,000 300,000 Salvage Value Depreciation Purchase Date Method N/A N/A 15,500 Straight line 10,500 Straight line 1-Jun-18 1-Jun-18 1-Oct-18 4 25,000 production 1-Aug-18 5 40,000 production 1-Jan-19 Delivery Equipment 1,811,000 Additional information related to the $485,000 assembly equipment purchase: It is ESTIMATED that the equipment will be ABLE TO ASSEMBLE 250,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 60260 62560 63500 68700 255020 Additional information related to the $300,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 Year 5 32,680 49,500 48,840 49,900 46,500 227,420 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 Asset Depreciation Cost per unit Units of Depreciation Accumulated Book Production Expense Depreciation Value Delivery Equipment Depreciation Schedule Depreciation for the Year Depreciation Date Asset Cost per unit Units of Production Depreciation Expense Accumulated Depreciation Book Value JaJos Consulting and Sales Inc Cash Provided/Annual Year Cash Payment Requirement The company could issue $2,500,000 of long-term bonds, due in 5 years with a stated rate of interest, paid semiannually, of 4%. The market rate for similar debt is 6%. Cash Received Annual Cash Required The company could issue $2,000,000 of long-term bonds, due in 6 years with a stated rate of interest, paid semiannually, of 5%. 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 $5 per share The company will begin paying a dividend to all the common shareholders of $0.15 per share and this will continue into the future. Cash Received Annual Cash Required PARTIAL BALANCE SHEETS The company could issue $2,500,000 of long-term bonds, due in 5 years with a stated rate of interest, paid semiannually, of 4%. The market rate for similar debt is 6%. The company could issue $2,000,000 of long-term bonds, due in 6 years with a stated rate of interest, paid semiannually, of 5%. The market rate for similar debt is 4%. The company could issue 500,000 additional shares of $1 par value common stock for $5 per share The company will begin paying a dividend to all the common shareholders of $0.15 per share and this will continue into the future. JaJos Consulting and Sales Inc Financial Ratios and Calculations Option 1 Ratios Current Ratio Current Assets Current Liabilities The company could issue $2,500,000 of long-term bonds, due in 5 years with a stated rate of interest, paid semiannually, of 4%. The market rate for similar debt is 6%. Option 2 Option 3 The company could issue $2,000,000 of long-term bonds, due in 6 years with a stated rate of interest, paid semiannually, of 5%. The market rate for similar debt is 4%. The company could issue 500,000 additional shares of $1 par value common stock for $5 per share The company will begin paying a dividend to all the common shareholders of $0.15 per share and this will continue into the future. Debt to Asset Ratio Total Debt Total Assets Debt to Equity Total Debt Total Equity Return on Equity Net Income Total Equity Return on Assets Net Income Total Assets