Question

Q4 D (20 Marks) Year 0 $5,400,000 Years 1-12 Investment 1. Sales 2. Variable costs 3. Fixed costs 4. Depreciation 5. Pre-tax

please provide the fomulas as well it will be
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Year 0 Year 1-12 FORMULAS ($5,400,000) a given J5 * 83% b(a*83%) C Particulars Investment 1. Sales 2. Variable cost 3. Fixed

Add a comment
Know the answer?
Add Answer to:
please provide the fomulas as well it will be Q4 D (20 Marks) Year 0 $5,400,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please answer in excel V-Formula Example: Example involves the development of a new restaurant property. The...

    please answer in excel V-Formula Example: Example involves the development of a new restaurant property. The land, building, and equipment investment required to construct the restaurant is a combined $1.5 million dollars. Estimated sales are $1.4 million, with an operating profitability (defined as EBITDA as a per of sales) of 20%. The variables to complete this exercise are listed below. Table 1 Current Pre-Tax ROE Example VARIABLE AMOUNT 1. Investment $1,500,000 2. Sales $1,400,000 3. Operating Profit Margin 20% of...

  • The years 0-4 have to be calculated as well as the NPV. Assume that in the...

    The years 0-4 have to be calculated as well as the NPV. Assume that in the original Ityesi example in Table , all sales actually occur in the United States and are projected to be $60.0 million per year for four years. Keeping other costs the same, calculate the NPV of the investment opportunity. Assume the WACC is 6.8%. The forward exchange rates are given below. 1 Year Forward Exchange Rate ($/£) 0 1.6000 2 1.5115 3 1.4692 4 1.4280...

  • The years 0-4 have to be calculated as well as the NPV. Assume that in the...

    The years 0-4 have to be calculated as well as the NPV. Assume that in the original Ityesi example in Table , all sales actually occur in the United States and are projected to be $60.9 million per year for four years. Keeping other costs the same, calculate the NPV of the investment opportunity. Assume the WACC is 6.4%. The forward exchange rates are given below. 1 Year Forward Exchange Rate ($/£) 0 1.7499 2 1.6023 3 1.5784 4 1.4319...

  • The chart has to be filled out for years 0-4 as well as the NPV. Assume...

    The chart has to be filled out for years 0-4 as well as the NPV. Assume that in the original Ityesi example in Table , all sales actually occur in the United States and are projected to be $60.9 million per year for four years. Keeping other costs the same, calculate the NPV of the investment opportunity. Assume the WACC is 6.4%. The forward exchange rates are given below. 1 Year Forward Exchange Rate ($/£) 0 1.7499 2 1.6023 3...

  • Please remember to round your answer to two decimal places. Problem 11-02 Operating Cash Flow The...

    Please remember to round your answer to two decimal places. Problem 11-02 Operating Cash Flow The financial staff of Cairn Communications has identified the following information for the first year of the roll-out of its new proposed service: Projected sales $25 million Operating costs (not including depreciation) $9 million Depreciation $5 million Interest expense $4 million The company faces a 30% tax rate. What is the project's operating cash flow for the first year (t = 1)? Write out your...

  • Please show all working and answer all the questions if possible 1. Construct a balance sheet...

    Please show all working and answer all the questions if possible 1. Construct a balance sheet given the following data. What is shareholders' equity? Cash Inventory Plant and property Accounts receivable Accounts payable Long-term debt = $180,000 = $270,000 = $1,340,000 = $256,000 = $186,000 = $450,000 2. Lennox Furniture Company's 2016 balance sheet showed total current assets of $1,500,000. All of the current assets were required in operations, and its current liabilities consisted of $300.000 of accounts payable, $200,000...

  • Problem 12-01 AFN equation Broussard Skateboard's sales are expected to increase by 20% from $8.0 million...

    Problem 12-01 AFN equation Broussard Skateboard's sales are expected to increase by 20% from $8.0 million in 2016 to $9.60 million in 2017. Its assets totaled $5 million at the end of 2016. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2016, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is...

  • Please help me find the Cash Flow,NPV and IRR Assumptions Advertising Increase Per Year $2,000,000 Capital...

    Please help me find the Cash Flow,NPV and IRR Assumptions Advertising Increase Per Year $2,000,000 Capital Expenditures $4,000,000 One-Time Development Expenses $1,500,000 5-Year Depreciation Schedule Discount Rate 8% Tax 40% Base Case Cannibalization (Basic) 15%% Base Case Cannibalization (Premium) |(50% + 60%/2) = 55% Base Case Cannibalization (Advanced)|(65% + 75% /2) = 70% Base Case Marketing Per Year 6,000,000 Premium Product Basic Product Exhibit 6 Gross Profit Comparison Advanced Seal Per unit revenue and costs Revenue $22 Cost of goods...

  • PLEASE COMPLETE THE ANSWER SAT 1.1 SAT 1.2 SAT 1.3 SAT 1.4 RBB RETAILING CORPORATION Statement...

    PLEASE COMPLETE THE ANSWER SAT 1.1 SAT 1.2 SAT 1.3 SAT 1.4 RBB RETAILING CORPORATION Statement of Comprehensive Income For the year ended December 31, 2020 Net sales Less: Cost of sales 3,380,000 2,566,000 Gross profit 814,000 Less: Operating expenses Selling expenses General and administrative expenses Income before income tax 260,500 352,200 612.700 201,300 Less: Income tax expense 60,390 Net profit 140,910 Included under General and Administrative Expenses is the depreciation of the following account titles: a. Building - P80,000...

  • Please remember to round your answer to two decimal places. Problem 11-03 Net Salvage Value Allen...

    Please remember to round your answer to two decimal places. Problem 11-03 Net Salvage Value Allen Air Lines must liquidate some equipment that is being replaced. The equipment originally cost $20 million, of which 85% has been depreciated. The used equipment can be sold today for $6 million, and its tax rate is 30%. What is the equipment's after-tax net salvage value? Write out your answer completely. For example, 2 million should be entered as 2,000,000. $________ Problem 11-06 New-Project...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT