ACCT 209 University of London Prepare the Year End Balance Sheet for 20X1 Excel Task

DescriptionACCT 209
EXCEL PROJECT ASSIGNMENT INSTRUCTIONS
INSTRUCTIONS
Part 1: Assume ABC Company has asked you to prepare their 20X1 year-end Balance Sheet
based upon the below information.
End of the year information:
12/31/X1
Account
Ending Balance
Cash
50,000
Accounts Receivable
175,000
Inventory
126,000
Equipment
480,000
Accumulated Depreciation
90,000
Accounts Payable
156,000
Short-term Notes Payable
12,000
Long-term Notes Payable
200,000
Common Stock
235,000
Retained Earnings
solve
Part 2: ABC Company’s management is also considering 3 new projects consisting of the
purchase of new equipment. The company has limited resources and may not be able to
complete/make all 3 purchases. Therefore, calculate the NPV for each, and place the projects in
the order in which they should be completed using NPV as the reasoning. The information is as
follows for the purchases below.
Project 1
Project 2
Project 3
Purchase Price
$80,000
$175,000
$22,700
Required Rate of
Return
6%
8%
12%
Time Period
3 years
5 years
2 years
Cash Flows – Year 1
$48,000
$85,000
$13,000
Page 1 of 2
ACCT 209
Cash Flows – Year 2
$36,000
$74,000
$13,000
Cash Flows – Year 3
$22,000
$38,000
N/A
Cash Flows – Year 4
N/A
$26,800
N/A
Cash Flows – Year 5
N/A
$19,000
N/A
Required Action:
Part 1:

Prepare the year-end balance sheet for 20X1. Be sure to use proper headings and labels.
This should be done in Excel, using the first tab in the worksheet.
Part 2:

Using Excel formulas, calculate the NPV for each of the 3 potential 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).

This portion should be completed on a separate tab in Excel.
This assignment must be submitted as 1 Excel document, with 2 separate tabs.
Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.
Page 2 of 2

Purchase answer to see full
attachment

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.