Question: Please do on Excel. A project has the following information: accounting break-even quantity = 13,400 units; cash break-even quantity = 10,600 units; life = 5

Please do on Excel. A project has the following information: accounting break-even quantity = 13,400 units; cash break-even quantity = 10,600 units; life = 5 years, straight line; fixed costs = $150,000; variable costs = $24 per unit; required return = 12%. Ignoring the effect of taxes, find the financial break-even quantity. 2. Modified. Current output is 70,000 units with DOL of 3.00. If output rises to 75,000 units, what will be the percentage change in the operating cash flow? Please do on Excel 3. In previous problem, suppose fixed costs are $150,000. What is the operating cash flow at 67,000 units? The degree of operating leverage? 4. A proposed project has fixed costs of $84,000 per year. The operating cash flow at 7,500 units is $93,200. Ignoring the effect of taxes, what is the degree of operating leveraging? If units sold rise from 7,500 to 8,000, what will be the increase in operating cash flow? What is the new degree of operating leverage? Please do on Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

2. 10. Using break-even analysis [LO 11.3] Consider a project with the following data: accounting break-even quantity = 13 700 units; cash break-even quantity = 9,600 units; life = five years; fixed...

Consider a project with the following data: accounting break-even quantity = 14, 200 units; cash break-even quantity = 10, 300 units; life = five years; fixed costs = $170,000; variable costs = $27...

A project has an accounting break-even quantity of26,500 units, a cash break-even quantity of 17,120 units, life of 10 years, fixed costs of $178,000, variable costs of $18.40 per unit, and are...

1 . A project has the following information: accounting break - even quantity = 1 3 , 4 0 0 units; cash break - even quantity = 1 0 , 6 0 0 units; life = 5 years, straight line; fixed costs = $ 1 5 0...

Consider a project with the following data: accounting break-even quantity = 29,000 units; cash break-even quantity = 16, 250 units; life = 10 years; fixed costs = $203,000; variable costs = $24 per...

Week 6 Questions 1. A project has the following information: accounting break-even quantity = 13,400 units; cash break-even quantity = 10,600 units; life = 5 years, straight line; fixed costs =...

Consider a project with the following data: Accounting break-even quantity =19,000 units; cash break-even quantity =13,000 units; life = four years; fixed costs =$130,000; variable costs =$50 per...

introduction to finance210: what would be the OCK( PVIFA) 109,591.29 . number to get Using Break-Even Analysis: Consider a project with the following data: Accounting break-even quantity = 13,700...

Complete the following Income Statement to include the percentages. Note: Total Sales is the base (100%) Sales $ $ % Food Sales $485,100 Beverage Sales $396,900 Total Sales $882,000 Cost of Sales...

Kincaid Company sells flags with team logos. Kincaid has fixed costs of $ 583,200 per year plus variable costs of $ 4.80 per flag. Each flag sells for $ 12.00. Requirements 1. Use the equation...

6.A local bank advertises the following deal: "Pay us $100 a year for 10 years and then wewill pay you (or your beneficiaries) $100 a year forever." Is this a good deal if the interestrate available...

Zig and Yul have been negotiating the sale and purchase of Zig's accounting business. As well as the business, Zig is selling the office property in which the business is conducted. Having inspected...

=+Are you comfortable with your decision? Would you be embarrassed if it were printed in tomorrows newspaper or spread across the Internet?

=+That is, will a decision that seems ethical now seem unethical in the future?

=+Will the message achieve the greatest possible good while doing the least possible harm?