I am looking for someone that is willing to put together an accounting excel document together. Here are the specifics:  Required...

I am looking for someone that is willing to put together an accounting excel document together. Here are the specifics:

Required Action:

Part A:

• Prepare the year-end balance sheet for 2015. Be sure to use proper headings.
• Prepare budgets such that the pro-forma financial statements for the first quarter of 2016 may be prepared.

• Sales budget, including budgeted sales for April.
• Purchases budget, the budgeted cost of goods sold for each month and quarter, and the cost of the March 31 budgeted inventory.
• Selling expense budget.
• General and administrative expense budget.
• Expected cash receipts from customers and the expected March 31 balance of accounts receivable.
• Expected cash payments for purchases and the expected March 31 balance of accounts payable.
• Cash budget.
• Budgeted income statement.
• Budgeted statement of retained earnings.
• Budgeted balance sheet.

Part B:

• Calculate using Excel formulas, the NPV of each of the 3 projects.
• It is possible that ABC Company may not be able to complete all 3 projects. Therefore, advise ABC Company as to the order in which they should pursue the projects (i.e., which project should ABC Company attempt to do first, second, and last).
• Provide justification and analysis as to why you chose the order you did. The analysis must also be done in Excel, not in a separate document.