Question
please answer in excel
V-Formula Example: Example involves the development of a new restaurant property. The land, building, and equipment investmen
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Calculation of Pre-tax ROE
Amount in $
Operating Profit 280000
Less: Interest 101250 Interest payment on the borrowings of $1125000
178750
Less: Depreciation 30000 I assume that Annual capital investment is nothing but depreciation or amortisation
Pre tax Profit 148750
Investment in Equity 375000
Pre-tax ROE in (%) 39.67 Pre tax Profit/Investment in equity 148750/375000
Add a comment
Know the answer?
Add Answer to:
please answer in excel V-Formula Example: Example involves the development of a new restaurant property. The...
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
  • Use the following information about Company X to help answer problems 1-10. Company X went public...

    Use the following information about Company X to help answer problems 1-10. Company X went public at the start of 2016, $100M shares of stock were issued at $18.60 per share. At the end of 2016, Company X traded at $20.00 per share. During 2017, Company X issued 5 shares at $20.00 per share, thus raising $100M of capital At the end of 2017, Company X traded at $20.46 per share. A summary of Company X's 2016 and 2017 10k...

  • please use excel to answer the questions and show all outputs E3) The Erley Equipment Company...

    please use excel to answer the questions and show all outputs E3) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight line method toward a salvage value of $10,000, or by $9,000 per year. A new machine can be...

  • COMPLE THE ANSWER SAT 1.5 SAT 1.6 SAT 1.7 SAT 1.8 SAT 1.9 SAT 1.10 During...

    COMPLE THE ANSWER SAT 1.5 SAT 1.6 SAT 1.7 SAT 1.8 SAT 1.9 SAT 1.10 During the year 2020, the Belleview Company had generated total sales revenue of P1,000,000, of which P990,000 were collected during the year, including collections of P120,000 sales revenue made in 2019. The company purchased goods costing P600,000, paid P650,000 to merchandise suppliers including payment for goods purchases in 2019 of P80,000. Included in P180,000 operating expenses was depreciation of P35,000. Accrued operating expenses decreased by...

  • 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...

  • SAT 1.1 SAT 1.2 SAT 1.3 SAT 1.4 SAT 1.5 SAT 1.6 SAT 1.7 SAT 1.8...

    SAT 1.1 SAT 1.2 SAT 1.3 SAT 1.4 SAT 1.5 SAT 1.6 SAT 1.7 SAT 1.8 SAT 1.9 SAT 1.10 I need complete answer 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...

  • please fill in andwers in the yellow cells Toefield Inc. has developed a powerful efficient snow...

    please fill in andwers in the yellow cells Toefield Inc. has developed a powerful efficient snow remover that is significantly less polluting than existing snow removers currently on the market. The company spent $2,000,000 developing this product and the marketing department spent ano ther $300,000 to assess the market demand. It would cost $20 million at Year 0 to buy the equipment necessary to manufacture the efficient snow blower. The project would require net working capital at the beginning of...

  • CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in...

    CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in Appendix A. Required: Compute the following ratios for Year 11. Liquidity ratios: Asset utilization ratios:* a. Current ratio n. Cash turnover b. Acid-test ratio 0. Accounts receivable turnover c. Days to sell inventory p. Inventory turnover d. Collection period 4. Working capital turnover Capital structure and solvency ratios: 1. Fixed assets turnover e. Total debt to total equity s. Total assets turnover f. Long-term...

  • 5. Please answer the following questions with respect to PLC Theory (8) a. Which phase of...

    5. Please answer the following questions with respect to PLC Theory (8) a. Which phase of the PLC is the pizza business? What indicators can you list? b. Given the phase of the PLC you indicated at part a: 1. What marketing mix strategies would you expect Dominos to be using? il. What marketing mix strategies is Dominos actually using? Ill. What disconnects, issues or questions arise from parts I and il above? The Strategy Carrying Domino's to New Heights...

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