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

profilerockik8vo

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.

 

  • 5 years ago
  • 50
Answer(2)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    excel_project.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    budgeted_excel_project.xlsx