Show formula used. AllgnmentNumberStylesCellsEditingA5f 1ABCJ.K72Table D-1Table D-273Initial Investment2677437RevenueCostCash FlowYear74Cost of Capital.25%75Weekly Revenue14,85076Weekly ExpensesSelling Price3,9006,000,00027778479New Yearly Revenue80New Yearly Expenses81There are 52 weeks in a year.828.83NPV84IRR85868788F.

The given problem can be solved using NPV and IRR function in excel.

Answered: how formula used.

Business

Finance

how formula used.

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, capital- beg. ₱100,000Additional investment 90,000Drawings 40,000Net income 250,000A, capital- end ?
LiabilitiesOMRAssetsOMRShare capital400,000Land and building280,000Net profit60,000Plant and machinery700,000General reserve80,000Stock400,000Debentures840,000Debtors200,000Creditors200,000Bills receivables20,000Bills payable100,000Cash80,000Total1,680,000Total1,680,000 1>calculate total current liabilites 2>calculate total Current assets
A4 9c We find the following information on NPNG (No-Pain-No-Gain) Inc.: EBIT = $2,000,000Depreciation = $250,000Change in net working capital = $100,000Net capital spending = $300,000 These numbers are projected to increase at the following supernormal rates for the next three years, and 5% after the third year for the foreseeable future: EBIT: 20%Depreciation: 10%Change in net working capital: 15%Net capital spending: 10% The firm’s tax rate is 35%, and it has 1,000,000 outstanding shares and $8,000,000 in debt. We have estimated the WACC to be 15%. c. Calculate the firm’s share price at time 0.
A4 9a We find the following information on NPNG (No-Pain-No-Gain) Inc.: A4 9a EBIT = $2,000,000Depreciation = $250,000Change in net working capital = $100,000Net capital spending = $300,000 These numbers are projected to increase at the following supernormal rates for the next three years, and 5% after the third year for the foreseeable future: EBIT: 20%Depreciation: 10%Change in net working capital: 15%Net capital spending: 10% The firm’s tax rate is 35%, and it has 1,000,000 outstanding shares and $8,000,000 in debt. We have estimated the WACC to be 15%. a. Calculate the EBIT, Depreciation, Changes in NWC, and net capital spending for the next four years.
$1897 mibns 000,0062 sw I Y al coles a bl 6) The Kaufmann Group is considering a $364,000 investment with the following net cash flows. Kauffman requires a 12% return on its investments. Annual Net Cash Flows Present Value of $1 at 12% Initial investment 1.0000 Year 1 $ 124,000 0.8929 Year 2 84,000 0.7972 Year 3 144,000 0.7118 Year 4 s istos bas 000,00 254,000 svenistot 008,20 0.6355 by Year 5 74,000 0.5674 The present value of this investment is: A) B) C) D) E) $483,588. $161,576. $119,588. $230,308. $281,005.
If current assets are $100,000 and current liabilities are $42,000, what is the working capital?A. 200 percentB. 50 percentC. 2.0D. $58,000
Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000 You are required to:iv) Calculate the cash flow from assets v) Calculate net capital spending vi) Calculate change in NWC
Use the following information to answer the questionsProperty:Purchase Price$7,017,000Acquisition Costs$0Year 1 PGI$1,263,060PGI Growth Rate/year4.0%Year 1 Miscellaneous Income$0Miscellaneous Income Growth Rate/year0.0%Annual Vacancy and Collection Losses/year11.0%Year 1 Operating Expense$415,926Operating Expense Annual Growth Rate2.8%Year 1 Capital Expenditures$38,220Capital Expenditures Annual Growth Rate1.6%Holding period (years)5Property to be sold for NOI6 capitalized at (Terminal Cap Rate):7.5%Selling Expenses in year 56.5%Financing:LTV67%Loan Costs (% of Mortgage Value)1.40%Loan term (years)30Monthly Amortization / monthly paymentsLoan is a 2/2 ARMLoan Rate = T-Bill + 0.37%Teaser Rate3.420%T-Bill Rate at Initiation2.990%T-Bill on Reset Date 15.540%T-Bill on Reset Date 25.910%T-Bill on Reset Date 36.850%T-Bill on Reset Date 47.250%T-Bill on Reset Date 58.120%T-Bill on Reset Date 68.900%Pre-tax Required Return32.00% 1-Find the annual debt service in year 3 2-Find the Annual Debt…
Use the following information Year 0 1 2 3 Cash flow -$1000 $300 $500 $700 WACC= 8.0% Calculate: a) NPV b) IRR c) Payback d) MIRR e) EAA
Q) For a given company studies indicate that due to the nature of contract business, any excess funds generated are expected to earn at a rate of 11% per year. Use the ROIC method to determine the rate of return on invested capital value for the given cash flow series.(X0=$2,000, X1=$-900, X2=$-7,000, X3=$6,900) Explain it early but not in excel works. Typed or handwriting onlys
Question 2 Sunshine Corporation is reviewing an investment proposal. The initial cost of the investment isR52 500. The estimated cash flows and net profit for each year are presented in the schedulebelow. All cash flows are assumed to take place at the end of the year. year Net cash flows Net profit R20 000 R2 500 R17 500 R3 500 R15 000 R4 500 R12 500 R5 500 R10 000 R6 500 The cost of capital is 12%. Required:Calculate the following:1. Payback Period 2. Net Present value 3. Accounting rate of return
From the following forecast the Balance sheet for the year 2021Balance sheet as of 31/12/2020Liabilities& Equity AmountAssetsAmountEquity33,000 Plant and machinery 10,000Retained earnings 10,000 Land Property20.000Accounts payable 7,000 Accounts receivables 3.000Inventories10.000Cash in hand2000Cash at Bank5.00050,00050,0001. It is expected that the company will make a net income of10% of forecasted sales2. The company will purchase additional 5000 OMR worthmachines by taking an additional loan of 5000 OMR3. Forecasted sales OMR 100,0004. Dividend payout will be 50%5. The following estimates are also given;Accounts payable 10,000Accounts receivable 6,000Inventories 15,000Cash in hand 6.000Cash at bank 1,000

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