Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
EXCEL PROJECT INSTRUCTIONS
Assume ABC Company has asked you to not only prepare their 2015 year-end Balance Sheet but to also provide pro-forma financial statements for 2016. In addition, they have asked you to evaluate their company based on the pro-forma statements with regard to ratios. They also want you to evaluate 3projects they are considering. Their information is as follows:
End of the year information:
Account
12/31/15 Ending Balance
Cash
50,000
Accounts Receivable
175,000
Inventory
126,00
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
Additional Information:
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 3purchases. 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
$15,000
Cash Flows - Year 2
$36,000
$74,000
$12,000
Cash Flows - Year 3
$22,000
$38,000
N/A
Cash Flows - Year 4
$26,800
Cash Flows - Year 5
$19,000
Required Action:
Part A:
Part B:
This assignment must be submitted as 1 Excel document.
shown below is a segmented income statement for hickory companys three wooden flooring product
The events and transactions listed below took place in the General Fund of Lawton City during fiscal 2013. Prepare the necessary general journal entries.
It did not pay any dividends during the year. By what amount would Athlon's investment in Opteron Corporation increase for the year, if Athlon used the equity method.
garber plumbers offers a 20 trade discount when providing 2000 or more of plumbing services to its customers. in march
How would accounting software requirements for large corporations differ from requirements for small companies?
Briefly describe the accounting for ESOs. Why is there a cost when a company grants ESOs with an exercise price equal to the current market price?
the main purpose of this module is to review the balance sheet in more detail.is there a difference in approach to
In Row 23, calculate totals for cash payments, interest expense, and applied to principal.
kazaam company a merchandiser recently completed its calendar-year 2011 operations. for the year 1 all sales are credit
Explain the importance of full disclosure in source of capital processes.
Why is a hierarchy of generally accepted accounting principles needed?
Identify and describe the three tools of financial statement analysis. Perform each of the three types of analysis on Drew Carey’s current assets. What conclusions about the management of accounts receivable can be drawn from these data?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd