AutoSave ABC Home Insert Draw Page Layout Formulas Data Review View Automate X Paste Aptos Narrow...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
AutoSave ABC Home Insert Draw Page Layout Formulas Data Review View Automate X Paste Aptos Narrow (Bod... v BIU V 12 Wrap Text v Tell me Book2 General Av Merge & Center V $ % 9 13 fx A B C D E F G Table 1 1 Projected Unit Sales and Price for Lazy Mower 2 Year 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Find NPV and IRR S76222222222223523333224 18 Sheet1 Sheet2 + Ready Accessibility: Investigate V Insert v Delete v Conditional Format Cell Formatting as Table Styles Format v WEA H < < Comments Share Sort & Filter Find & Select Add-ins Analyze Data D J K L M N VC per unit TAX rate Unit Sales Unit price sale revenue Varible cost 1 200,000 700 140000000 80000000.00 2 240,000 700 168000000 96000000.00 3 288,000 700 201600000 115200000.00 Contribution Margin 60000000.00 2000000 72000000.00 2000000 86400000.00 2000000 FC DEP 0.33 Taxable Income + Taxes NPV 400 44.44 14.82 4 280,000 650 182000000 112000000.00 5 260,000 650 169000000 6 260,000 650 169000000 7 255,000 650 165750000 104000000.00 104000000.00 102000000.00 8 250,000 600 9 245,000 10 240,000 600 600 150000000 147000000 144000000 100000000.00 50000000.00 70000000.00 2000000 65000000.00 2000000 2000000 65000000.00 2000000 63750000.00 2000000 7.41 0.00 0.00 0.00 0.00 98000000.00 96000000.00 49000000.00 2000000 48000000.00 2000000 #N/A #N/A MacBook Pro B + 100% AutoSave ABC Home Insert Draw Page Layout Formulas Data Review View Automate X Paste Aptos Narrow (Bod... v BIU V 12 Wrap Text v Tell me Book2 General Av Merge & Center V $ % 9 13 fx A B C D E F G Table 1 1 Projected Unit Sales and Price for Lazy Mower 2 Year 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Find NPV and IRR S76222222222223523333224 18 Sheet1 Sheet2 + Ready Accessibility: Investigate V Insert v Delete v Conditional Format Cell Formatting as Table Styles Format v WEA H < < Comments Share Sort & Filter Find & Select Add-ins Analyze Data D J K L M N VC per unit TAX rate Unit Sales Unit price sale revenue Varible cost 1 200,000 700 140000000 80000000.00 2 240,000 700 168000000 96000000.00 3 288,000 700 201600000 115200000.00 Contribution Margin 60000000.00 2000000 72000000.00 2000000 86400000.00 2000000 FC DEP 0.33 Taxable Income + Taxes NPV 400 44.44 14.82 4 280,000 650 182000000 112000000.00 5 260,000 650 169000000 6 260,000 650 169000000 7 255,000 650 165750000 104000000.00 104000000.00 102000000.00 8 250,000 600 9 245,000 10 240,000 600 600 150000000 147000000 144000000 100000000.00 50000000.00 70000000.00 2000000 65000000.00 2000000 2000000 65000000.00 2000000 63750000.00 2000000 7.41 0.00 0.00 0.00 0.00 98000000.00 96000000.00 49000000.00 2000000 48000000.00 2000000 #N/A #N/A MacBook Pro B + 100%
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
A module can be considered a(n) object or unit that can be combined or bound together to form a application. a. Dependent, big and complex b. Dependent, small and easier c. Independent, big and...
-
One mole of an ideal diatomic gas is heated at constant volume from 300 to 600 K. (a) Find the increase in internal energy, the work done, and the heat added. (b) Find the same quantities if this gas...
-
A sole trader can take drawings from a business. How would someone who is a director and shareholder of a business be rewarded?
-
Who establishes a zone of indifference for employees?
-
During January 2011, Aragorn Inc. purchased the following securities: During 2011, Aragorn received interest from Mirkwood and the U.S. Treasury totaling $3,630. Dividends received on the stock held...
-
That portion of the share capital which cannot be called - up except on the winding up is known as A ) Called - up Capital B ) Paid - up Capital C ) Authorised Capital D ) Reserve Capital
-
Find the equation of the parabola having the following properties (i) (ii) (iii) (iv) 30 vertical stretch by factor of 6 opening up horizontal translation 6 units to the right vertical translation 3...
-
Discuss the impact of microbiologically influenced corrosion (MIC) on industrial systems, including the role of bacteria and biofilms in accelerating corrosion processes and the strategies employed...
-
The Righton Corporation is taking out a loan of $38,000 at 7.8% interest (see table below). This interest rate is locked in for the life of the loan. They recognize that if/when they want to take out...
-
Consider the following data that illustrates demand and production costs for a given product. Jan Feb Mar Apr 150 175 200 120 Demand (units) Production Cost (S/unit) 30 35 20 25 Inventory carrying...
-
Talia Jackson, head of Human Resources with Blue Diamond Insurance, recently planned an awards lunch for the 50 top-performing insurance agents in the region. In previous years, the insurance company...
-
Convert from base 10 to base 2 on 8 bits: 25510 = 2
-
There are many tall buildings across the United States. The Singer Building in New York City was one of the first ones built and it was completed in 1908. Since then, many more tall buildings and...
-
Highland Theatre is owned by Finnean Ferguson. At June 30, 2014, the ledger showed the following: Cash, $6,000; Land, $100,000; Buildings, $80,000; Equipment, $25,000; Accounts Payable, $5,000;...
-
In February 2005, Maggie Sharrer invested $12,000 in Gardentech, Inc. Gardentech's accountant, Jori Aloisio, recorded this receipt as an increase in cash and revenues. Is this treatment appropriate?...
-
Listed below are some items found in the financial statements of Jan Way Inc. Indicate in which financial statement the following items would appear. (a) Advertising expense. (d) Cash. (b) Equipment....
-
Summarized operations for the Alica Cosky Co. for the month of July are as follows. Revenues earned: for cash $45,000; on account $95,000. Expenses incurred: $43,000. for cash $26,000; on account...
Study smarter with the SolutionInn App