5 1. Learning Objectives (a) Develop proforma Project Income Statement Using Excel Spreadsheet 7 (b) Compute...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5 1. Learning Objectives (a) Develop proforma Project Income Statement Using Excel Spreadsheet 7 (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period 8 (c) Develop Problem-Solving and Critical Thinking Skills 9 10 111) Life Period of the Equipment = 4 years 12 2) New equipment cost 133) Equipment ship & install cost 14 4) Related start up cost 15 5) Inventory increase 16 6) Accounts Payable increase 17 7) Equip. Salvage Value Estimated 18 End of Year (fully depreciated) 19 20 21 ESTIMATING Initial Outlay (Cash Flow, CFO, T= 0) 22 23 YEAR 24 25 Investments: 281) Equipment cost 27 2) Shipping and Install cost 283) Start up expenses 29 30 4) Net Working Capital 31 Inventory Inc.- Acct. Payable Inc. 32 33 Total Initial Outlay Total Basis Cost (1+2+3) 34 35 Operations: 06 Revenue 37 Operating Cost 38 Depreciation 00 EBIT 40 Taxes 41 14 15 Net Income (LOSS) 12 43 Add back Depreciation TO 31 TAX SHIELD DUE TO LOSS Total Operating Cash Flow 16 17 Terminal (END of 4th YEAR) 1) Release of Working Capital 2) Salvage value (after tax) Total Sheet1 Shoein $ $ $ $ $ $ 5555 $ $ $ S D 8) Sales for first year (1) (221,000) 9) Sales increase per year (35,000) 10) Operating cost: CF0 Q -60% (5,000) (60 Percent of Sales 25,000 11) Depreciation (Straight Line)/Y S 5,000 12) Tax rate 15,000 13) Cost of Capital (WACC) (221,000) (35,000) (5,000) (261,000) (20,000) $ (281,000) CF1 1 S $ CF2 2 - $ $ G ####* $(60,000) $(60,000) $ (60,000) $ XXXXX XXXXXXXXXX XXXXXXXXX CF3 3 $ $ xxXxXxXxxxXxxxXxx xxxXXXXX XXXXXXX XXXXXXXXX $ 200,000 28% $ (120,000) I CF4 4 (60,000) XXXXXXXX (60,000) 35% 10% XXXXXXXXX $ 20,000 5 1. Learning Objectives (a) Develop proforma Project Income Statement Using Excel Spreadsheet 7 (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period 8 (c) Develop Problem-Solving and Critical Thinking Skills 9 10 111) Life Period of the Equipment = 4 years 12 2) New equipment cost 133) Equipment ship & install cost 14 4) Related start up cost 15 5) Inventory increase 16 6) Accounts Payable increase 17 7) Equip. Salvage Value Estimated 18 End of Year (fully depreciated) 19 20 21 ESTIMATING Initial Outlay (Cash Flow, CFO, T= 0) 22 23 YEAR 24 25 Investments: 281) Equipment cost 27 2) Shipping and Install cost 283) Start up expenses 29 30 4) Net Working Capital 31 Inventory Inc.- Acct. Payable Inc. 32 33 Total Initial Outlay Total Basis Cost (1+2+3) 34 35 Operations: 06 Revenue 37 Operating Cost 38 Depreciation 00 EBIT 40 Taxes 41 14 15 Net Income (LOSS) 12 43 Add back Depreciation TO 31 TAX SHIELD DUE TO LOSS Total Operating Cash Flow 16 17 Terminal (END of 4th YEAR) 1) Release of Working Capital 2) Salvage value (after tax) Total Sheet1 Shoein $ $ $ $ $ $ 5555 $ $ $ S D 8) Sales for first year (1) (221,000) 9) Sales increase per year (35,000) 10) Operating cost: CF0 Q -60% (5,000) (60 Percent of Sales 25,000 11) Depreciation (Straight Line)/Y S 5,000 12) Tax rate 15,000 13) Cost of Capital (WACC) (221,000) (35,000) (5,000) (261,000) (20,000) $ (281,000) CF1 1 S $ CF2 2 - $ $ G ####* $(60,000) $(60,000) $ (60,000) $ XXXXX XXXXXXXXXX XXXXXXXXX CF3 3 $ $ xxXxXxXxxxXxxxXxx xxxXXXXX XXXXXXX XXXXXXXXX $ 200,000 28% $ (120,000) I CF4 4 (60,000) XXXXXXXX (60,000) 35% 10% XXXXXXXXX $ 20,000
Expert Answer:
Answer rating: 100% (QA)
a Proforma Project Income Statement Using Excel Spreadsheet Particulars Year 0 Year 1 Year 2 Year 3 Year 4 Sales Costs Depreciation EBIT Tax Net incom... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-0324597707
12th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these databases questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Prepare a Common Size Analysis and Trend Analysis for three years for the Income Statement, Balance Sheet and Cash Flows Statement of Excel Corporation (There is a separate worksheet for each of...
-
What is the timestep value ? And how do I go about altering from downstream to upstream? The following code solves the advection equation 1 2 3 4 5 6 7 8 9- 10 - 11 12 - 13 - 14 - 15 - 16 - 17 18 19...
-
Explain why traditional cost allocation methods fail in a computer-integrated manufacturing environment
-
Passat Company owns a building that appears on its prior year-end balance sheet at its original $561,000 cost less $420,750 accumulated depreciation. The building is depreciated on a straight-line...
-
Identify all the integers in the following list: \(4,-17,8,0.5, \sqrt{7}, \frac{1}{9},-300\).
-
Cost data for Tiwana Manufacturing Company for the month ended May 31, 2014, are as follows: a. Prepare a cost of goods manufactured statement for May 2014. b. Determine the cost of goods sold for...
-
U.S business entities are taxed according to one of three basic sets of rules - (1) separate legal entity, flow-through, or the "either/or" approach. (For this question, you may ignore the...
-
Caitlin and Wally formed the C & W Partnership on September 1, 2020. Caitlin contributed cash of $195,000, and Wally contributed office furniture with a FMV of $66,000. He bought the furniture for...
-
The Sarbanes Oxley Act of 2002: A. requires public companies to issue in writing that financial reports are accurate and complete, and that internal controls are adequate to prevent material...
-
what's the theory in leadership? and what's the challenges and the opportunities in leadership?
-
Openining balance 51,484 , January 3Received a check from Horsfield Happy Ice Cream as partial payment onaccount in the amount of $5,000.00. January 10Receive a check from Horsfield Happy Ice Cream...
-
Josie is an accounting supervisor at Monk & Sons Realty. She instructs her subordinate, Maria, to make certain accounting entries in the company\'s books that will increase revenue by a material...
-
CHALLENGE 5.19.1: Delete from dictionary. ACTIVITY Delete Prussia from country_capital. Sample output with input: 'Spain: Madrid, Togo:Lome, Prussia:Konigsberg' Prussia deleted? Yes. Spain deleted?...
-
1. Based on your understanding of Herzberg's two-factor theory of job satisfaction, what types of incentives or employee programs are most likely to reduce job dissatisfaction? What types of...
-
coding to alert the user with the led that it is pray time with following informations using arduino IDE Next Prayer is isha and starts in 13 minutes. Today Prayer Times in Jeddah (Makkah Province...
-
Perform the indicated operations. In designing a cam for a fire engine pump, the expression is used. Simplify this expression. (3) (3 4 32
-
Nevada Enterprises is considering buying a vacant lot that sells for $1.2 million. If the property is purchased, the companys plan is to spend another $5 million today (t = 0) to build a hotel on the...
-
Storm Software wants to issue $100 million in new capital to fund new opportunities. If Storm raised the $100 million of new capital in a straight-debt 20-year bond offering, Storm would have to...
-
What is a replacement chain? When and how should replacement chains be used in capital budgeting?
-
If the terms such as those in Problems 7 and 8 appear in the flow equations solved by an RANS method, do they need closure models? Explain your answer.
-
For the flow analysis in Problem 10, consider the situation when temperature is not constant. There is an internal heat source with volumetric rate \(Q\). The duct's walls are thermally insulated....
-
A steady-state turbulent flow through a long coiled duct is modeled using the standard \(k-\epsilon\) model. Assuming the fluid is incompressible and isothermal, write the full system of equations...
Study smarter with the SolutionInn App