Part 1: Assume ABC Company has asked you to prepare their 20X1 year-end Balance Shee based...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 1: Assume ABC Company has asked you to prepare their 20X1 year-end Balance Shee 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 Long-term Notes Payable 200,000 Common Stock 235,000 solve 7 Retained Earnings 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 6% 8% 129 Return Time Period 3 years 5 years 2 years Cash Flows-Year 1 $48,000 $85,000 $13,000 N of 2 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: C 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 (ie., which project should ABC Company attempt to do first, second, and last). This portion should be completed on a separate tab in Excel Part 1: Assume ABC Company has asked you to prepare their 20X1 year-end Balance Shee 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 Long-term Notes Payable 200,000 Common Stock 235,000 solve 7 Retained Earnings 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 6% 8% 129 Return Time Period 3 years 5 years 2 years Cash Flows-Year 1 $48,000 $85,000 $13,000 N of 2 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: C 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 (ie., which project should ABC Company attempt to do first, second, and last). This portion should be completed on a separate tab in Excel
Expert Answer:
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these finance questions
-
A large urban police department's CSI unit laboratory has 2 0 identical, very accurate and very expensive scanning electron microscopes available for use by its crime scene investigators. Assume...
-
Suppose you are provided with a lambda expression that works with numbers in the sense of part (a) above and which will find the predecessor of any nonzero number. Express the factorial function in...
-
You are conducting a Goodness of Fit hypothesis test for the claim that the 4 categories occur with the following frequencies: H0 : pA=0.3; pB=0.1; pC=0.5; pD=0.1 a) Complete the table below. Give...
-
1. If the nominal policy interest rate is 5% and the expected rate of inflation is 3%, what is the value for the vertical intercept of the LM curve? 2. If the expected rate of inflation were to...
-
Let () be a p.d.f. that is defined as follows for constants >0 and >0: A distribution with this p.d.f. is called an inverse gamma distribution. a. Verify that () is actually a p.d.f. by verifying...
-
When Microsoft went public, the company sold 2 million new shares (the primary issue). In addition, existing shareholders sold .8 million shares (the secondary issue) and kept 21.1 million shares....
-
Why is it important to monitor actual versus forecast data in the run up to an event?
-
The information provided in this assignment is in relation to a Nova Scotia company named Fairness Enterprise that is owned and run by G. Steinem. Faimess Enterprise offers consulting services to...
-
Find the axis of symmetry and vertex for the parabola y = x - 2x + 3. Provide your answer below:
-
Mike's Radiator Services specializes in the repair and replacement of radiators for passenger vehicles. Variable and fixed costs related to installation activities for the most recent month (January)...
-
Problem 10-4 (Static) Software upgrade times (in minutes) are being evaluated. Samples of five observations each have been taken, and the results are as listed. SAMPLE 1 2 3 4 5 6 79.2 80.5 79.6 78.9...
-
Investigate the role of advanced structural health monitoring (SHM) technologies, such as distributed fiber optic sensors, wireless sensor networks, and machine learning algorithms, in continuously...
-
If a share expects next year's dividend to be$1.35 and the company's average dividend growth rate is expected to be 6%,then what is the intrinsic value of the share if the market rate is 9.5%?
-
ArraySum Method to transform a number of an array Assume that we receive two numbers with the same number of digits. We should transform each number into an array of integers that represent the given...
-
Investigate the integration of advanced geospatial data analytics, including remote sensing imagery analysis and geographic information system (GIS) mapping, in spatially explicit decision-making...
-
Discuss the role of advanced sustainability assessment tools, such as Life Cycle Assessment (LCA) and Environmental Impact Assessment (EIA), in evaluating the environmental, social, and economic...
-
a timeline visualization of your life events those have positively/negatively impacted your life. Take time by age on X axis: from age 1 till now. Take events on Y axis: place of Hight as weight of...
-
1) Predict the organicproduct formed when BzCl reacts with cyclohexanol. BzCl = benzoylchloride. 2) Provide the majororganic product of the reaction below. 3) Draw the structureof the product formed...
-
Name the various components of a measurement system.
-
Kemico Ltd manufactures a variety of chemicals which it supplies in bulk to industrial customers. Its factory at Gritborough employs 50 people, and its annual turnover in 1995 was 7.5M. During 1995,...
-
Define the term measurement.
Study smarter with the SolutionInn App