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...
-
A Watson Wyatt Worldwide survey showed that 58% of all Hispanic Americans are satisfied with their salary. Suppose a researcher randomly samples 27 Hispanic American workers and asks whether they are...
-
Photochronograph Corporation (PC) manufactures time series photographic equipment. It is currently at its target debt-equity ratio of .55. It's considering building a new $50 million manufacturing...
-
How is a service department charge rate determined?
-
Semtech Manufacturing purchased land and building for $4 million. In addition to the purchase price, Semtech made the following expenditures in connection with the purchase of the land and building:...
-
Support Department Cost Allocation-Reciprocal Services Method Brewster Toymakers Inc. produces toys for children. The toys are produced in the Molding and Assembly departments. The Janitorial and...
-
The CEO of Kuehner Development Co. has just come from a meeting with his marketing staff where he was given the latest market study of a proposed new shopping center, Parker Road Plaza. The study...
-
Use a truth table to prove the first Negation law: pV p=t Use a truth table to prove the second Negation law: p^~ p=c
-
Under the theory of vicarious liability, an employer may be responsible for the negligent actions of an employee. One important component of vicarious liability is that the employee must be acting...
-
What strategies can leaders employ to foster a culture of strategic agility, adaptability, and resilience within organizations, enabling them to navigate complex, turbulent environments, and...
-
How do leaders navigate the complexities of global market entry strategies, including market selection, entry mode choice, and adaptation of business models, to optimize international expansion...
-
ANA was driving her car on the way home when, suddenly two men on a motorcycle approached, knocked on her window, and point a gun at her. The two men were trying to steal from her but in her reaction...
-
A buyer purchased 75 ginger jar lamps at a list price of $40 each. The trade discounts were 20% and 5%, with terms of 2/10, net 30. The lamps were shipped and billed on October 18 and were received...
-
is a determining how operators and maintainers will be trained on a system is a common issue the test and evaluation ( T&E) IPT have to assess in planning & executing test activities ?
-
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?
-
What are five common methods for distributing partnership earnings?
-
What is the purpose of the owners' equity statement?
-
What account is debited when a partner withdraws cash for personal use?
Study smarter with the SolutionInn App