A firm has projected the following financials for a possible project:YEARSalesCost of GoodsS&ADepreciationInvestment in NWCInvestment in Gross PPE01,163.00104,285.001125,285.00262,893.00 62,893.0020,857.00125,285.0030,000.00 30,000.00526.00526.003125,285.004125,285.0030,000.00 30,000.0020,857.00 20,857.00 20,857.00What is the NPV of the project? (Hint: Be careful about rounding the WACC here!)62,893.00 62,893.00 62,893.00526.005526.00125,285.0030,000.0020,857.00526.00The firm has a capital structure of 46.00% debt and 54.00% equity. The cost of debt is 10.00%, while the cost of equityis estimated at 13.00%. The tax rate facing the firm is 38.00%. (Assume that you can't recover the final NWC position inyear 5. i.e. only consider the change in NWC for each year)

Net present is the difference between the present value of all cash inflows and initial investment…

YEAR Sales Cost of Goods S&A Depreciation Investment in NWC Investment in Gross PPE 0 1,163.00 104,285.00 2 125,285.00 125,285.00 125,285.00 62,893.00 62,893.00 3 526.00 30,000.00 30,000.00 30,000.00 30,000.00 20,857.00 20,857.00 20,857.00 526.00 62,893.00 62,893.00 125,285.00 125,285.00 526.00 5 526.00 62,893.00 30,000.00 20,857.00 20,857.00 526.00

YEAR Sales Cost of Goods S&A Depreciation Investment in NWC Investment in Gross PPE 0 1,163.00 104,285.00 2 125,285.00 125,285.00 125,285.00 62,893.00 62,893.00 3 526.00 30,000.00 30,000.00 30,000.00 30,000.00 20,857.00 20,857.00 20,857.00 526.00 62,893.00 62,893.00 125,285.00 125,285.00 526.00 5 526.00 62,893.00 30,000.00 20,857.00 20,857.00 526.00

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

A 2 Category 3 Sales 4 Cost of Goods Sold 15 a. Calculate ROA for current values. 16 Note: Round your answers to 2 decimal places. 17 18 SPM Outputs 19 Gross Profit 20 B Current Input Values $3,237,000.00 $2,490,000.00 $415,000.00 $161,850.00 $465,000.00 $162,000.00 $546,000.00 $492,000.00 5 Variable Expenses 6 Fixed Expenses 7 Inventory 8 Accounts Receivable 9 Other Current Assets 10 Fixed Assets 11 12 Required: 13 Note: Use cells A2 to C10 from the given information to complete this question. 14 Total Expenses 21 Net Profit 22 Net Profit Margin 23 Current Assets 24 Total Assets 25 Asset turnover 26 ROA (%) 27 28 b. Calculate ROA for new values. 29 Note: Round your answers to 2 decimal places. 30 31 SPM Outputs 32 Gross Profit 33 Total Expenses 34 Net Profit 35 Net Profit Margin 36 Current Assets 37 Total Assets 38 Asset turnover 39 ROA (%) 40 41 42 C New Input Values $3,560,700.00 $2,490,000.00 $383,875.00 $161,850.00 $395,250.00 $162,000.00 $546,000.00 $492,000.00 D E F TI G H I J K…
Calculate The sales from given information Costst of gold sold is $38000 Net income is $14625 Depreciation is $5000 Interest paid is 3500 Tax rate is 35%
A B C D E Sales revenue $40,400 $75,400 $573,700 $34,800 $54,100 Cost of goods sold 19,200 50,500 273,600 19,400 30,500 Operating expenses 9,800 39,800 230,700 11,800 17,900 Total expenses 29,000 90,300 504,300 31,200 48,400 Operating profit (loss) $11,400 $(14,900) $69,400 $3,600 $5,700 Identifiable assets $34,500 $80,000 $501,100 $64,700 $50,400 Sales of segments B and C included intersegment sales of $20,000 and $101,000, respectively. (a) Determine which of the segments are reportable based on the: 1. Revenue test. 2 Operating profit (loss) test. 3. Identifiable assets test. Reportable Segment
For 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, Chris Jenkins, the president, is presented with the following condensed comparative income statement: Macklin Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 $910,000 441,000 $469,000 $139,150 99,450 $238,600 $230,400 65,000 $295,400 65,000 $230,400 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income from operations Other revenue Income before income tax Income tax expense Net income 20Y1 $700,000 350,000 $350,000 $115,000 85,000 $200,000 $150,000 50,000 $200,000 50,000 $150,000 Required: Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. Use the minus sign to indicate a decrease in the "Difference".columns.
i need Part B solution Part A here solution Computation of net income: Net sales 680,400 Less: cost of goods sold (327,600) Gross profit 352,800 Less: administrative expense (126,000) Less: selling expense (100,800) Operational income 126,000 Discontinued operations (loss before income tax) (50,400) Income before tax 75,600 Less: income tax (30%) (22,680) Net income 52,920 Hence, net income for 2022 is calculated as €52,920.
Assume a $260,000 investment and the following cash flows for two products: Year Product X Product Y 1 23 $ 90,000 80,000 81,000 40,000 $ 80,000 70,000 50,000 80,000 a. Calculate the payback for products X and Y. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Product X Product Y years years
Law's 2021 cost of sales was a. $534,000 b. $500,000 c. $539,000 d. $470,000
After spending $10,000 on client-development, you have just been offered a big production contract by a new client. The contract will add $200,000 to your revenues for each of the next five years and it will cost you $100,000 per year to make the additional product. You will have to use some existing equipment and buy new equipment as well. The existing equipment is fully depreciated, but could be sold for $50,000 now. If you use it in the project, it will be worthless at the end of the project. You will buy new equipment valued at $30,000 and use the 5-year MACRS schedule to depreciate it. It will be worthless at the end of the project. Your current production manager earns $80,000 per year. Since she is busy with ongoing projects, you are planning to hire an assistant at $40,000 per year to help with the expansion. You will have to immediately increase your inventory from $20,000 to $30,000. It will return to $20,000 at the end of the project. Your company's tax rate is 35% and your…
Year Net Cash Flow Discount Factor Present Value (using the factor) Present Value (using Excel formula) 0 $ (3,500,000.00) 1 $(3,500,000.00) ($3,500,000.00) 1 $900,000.00 0.90909 $818, 181.00 $818, 181.82 2 $ 900,000.00 0.82645 $743,805.00 $743, 801.65 3 $900,000.00 0.75131 $676, 179.00 $676, 183.32 4 $ 900,000.00 0.68301 $614,709.00 $614,712.11 5 $900,000.00 0.62092 $558, 828.00 $558,829.19 Net Present Value $(88,298.00) $(88,291.91) 3. Now assume that inflation is estimated as a 5% increase each year (starting with Year 1) for the entire 5 years. Calculate the new net cash flow values for each year. Hint: You should start with 5% increase for Year 1 net cash flow.
Income Statement for Bearcat Hathaway, 2022 Sales Less Cost of Goods Sold Gross Profit Less General & Administrative Expenses $10,000,000 $2,470,732 $7,529,268 $1,438,438 $2,656,922 $3,433,908 $924,283 $2,509,625 $527,021 $1,982,604 $312,519 Less Depreciation Earnings Before Interest and Taxes Less Interest Paid Taxable Income (or Earnings Before Taxes) Less Taxes (21% Tax Rate) Net Income Dividends Calculate the operating cash flow. $6,090,830 $1,304,007 $3,433,908 $5,563,809 O $1,982,604
A company is considering expanding its production line. Cost for the the equipment for the expansion: Annual incease in sales: Number of years of the project: Annual operating costs other than depreciation: The company's tax rate: There is no change in Working Capital $200,000 $125,000 3 $50,000 35% The equipment will be depreciated on a 3 year straight line basis with 0 salvage value. At the end of 3 years the equipment disposed of at no cost or sale. Calcualte the Net Free Cash Flow for years 0 and 1 only as listed below. Do not use commas, decimals, or dollar signs. Enter negative numbers with a minus sign.
Question 8 Over the first 9 months of 2021, FNBA performed extremely well versus BAA regarding Yield on earning assets O Non-interest income Cost of funding earning assets

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS