Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.
35 Pages
Copy of FCF 9th edition Chapter 10
Course: BT 1003, Spring 2011School: American Jewish University
Rating:
Word Count: 1743
Document Preview
10 Problems Chapter 1-36 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select...
Unformatted Document Excerpt
Coursehero >> California >> American Jewish University >> BT 1003Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
10
Problems Chapter 1-36
Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK."
Chapter 10
Question 1 Input area:
Purchase price Appraised value Cost to build Grading costs
$6,000,000 $6,400,000 $14,200,000 $890,000
Output area:
The acquisition cost is a sunk cost. The appraisal value is an opportunity cost and should be included. The cost to build and grading costs are investments in fixed assets and are included. Total initial cost $21,490,000
Chapter 10
Question 2 Input area:
Camper quantity Camper price Increased motor home quantity Motor home price Lost motor coach quantity Motor coach price
19,000 $13,000 4,500 $53,000 900 $91,000
Output area:
Camper sales Increased motor home sales Lost motor coach sales Total sales
$247,000,000 238,500,000 (81,900,000) $403,600,000
Chapter 10
Question 3 Input area:
Projected sales Variable cost (% of sales) Fixed cost Depreciation Tax rate
$830,000 60% $181,000 $77,000 35%
Output area:
Sales Variable costs Fixed costs Depreciation EBT Taxes (35%) Net Income
$830,000 498,000 181,000 77,000 $74,000 25,900 $48,100
Chapter 10
Question 4 Input area:
Sales Variable cost Depreciation Tax rate
$824,500 $538,900 $126,500 34%
Output area:
Sales Variable costs Depreciation EBT Taxes (34%) Net Income OCF Depreciation tax shield
$824,500 538,900 126,500 $159,100 54,094 $105,006 $231,506 $43,010
Chapter 10
Question 5 Input area:
Projected sales Costs Depreciation Tax rate
$108,000 $51,000 $6,800 35%
Output area:
Sales Variable costs Depreciation EBT Taxes (35%) Net Income OCF OCF OCF OCF
$108,000 51,000 6,800 $50,200 17,570 $32,630 $39,430 $39,430 $39,430 $39,430
Chapter 10
Question 6 Input area:
Costs *7-year property under MACRS
$1,080,000
Output area:
Yr. 1 2 3 4 5 6 7 8
Beginning Book Value $1,080,000.00 925,668.00 661,176.00 472,284.00 337,392.00 240,948.00 144,612.00 48,168.00
MACRS 0.1429 0.2449 0.1749 0.1249 0.0893 0.0892 0.0893 0.0446
Depreciation Ending Book value $154,332.00 $925,668.00 264,492.00 661,176.00 188,892.00 472,284.00 134,892.00 337,392.00 96,444.00 240,948.00 96,336.00 144,612.00 96,444.00 48,168.00 48,168.00 -
Chapter 10
Question 7 Input area:
Costs Pretax salvage value Tax rate *Depreciation straight line *Asset used in years
$548,000 $105,000 35% 8 5
Output area:
Annual depreciation Accumulated depreciation Book value Aftertax cash flow
$68,500 $342,500 $205,500 $140,175
Chapter 10
Question 8 Input area:
Acquisition costs Pretax salvage value Tax rate *MACRS class for taxes
$7,900,000 $1,400,000 35% 0.2000 0.3200 0.1920 0.1152
Output area:
Book Value Aftertax cash flow
$1,365,120 $1,387,792
Chapter 10
Question 9 Input area:
Asset investment Estimated annual sales Costs Tax rate *Depreciation straight-line to zero over tax life
$3,900,000 $2,650,000 $840,000 35% 3
Output area:
OCF
$1,631,500
Chapter 10
Question 10 Input area:
Asset investment Estimated annual sales Costs Tax rate *Depreciation straight-line to zero over tax life OCF Required return
$3,900,000 $2,650,000 $840,000 35% 3 $1,631,500 12%
Output area:
NPV
$18,587.71
Chapter 10
Question 11 Input area:
Asset investment Estimated annual sales Costs Tax rate Required return *Depreciation straight-line to zero over tax life OCF Initial investment in NWC Fixed asset value at end
$3,900,000 $2,650,000 $840,000 35% 12% 3 $1,631,500 $300,000 $210,000
Output area:
Year 0 1 2 3 NPV
Cash flow $(4,200,000) $1,631,500 $1,631,500 $2,068,000 $29,279.79
Chapter 10
Question 12 Input area:
Asset investment Estimated annual sales Costs Tax rate Required return Initial investment in NWC Fixed asset value at end *3 yr MACRS
$3,900,000 $2,650,000 $840,000 35% 12% $300,000 $210,000 0.3333 0.4445 0.1481
Output area:
Year 0 1 2 3 Book value Aftertax salvage value NPV
Depreciation $1,299,870.00 $1,733,550.00 $577,590.00
Cash flow $(4,200,000.00) $1,631,454.50 $1,783,242.50 $1,916,303.00 $288,990 $237,647 $42,232.43
Chapter 10
Question 13 Input area:
Installation cost Operating cost per year Initial NWC Pretax salvage value Tax rate Discount rate *Depreciation straight-line over life
$560,000 $165,000 $29,000 $85,000 34% 10% 5
Output area:
Annual depreciation charge Aftertax salvage value OCF NPV
$112,000 $56,100 $146,980 $21,010.24
Chapter 10
Question 14 Input area:
Initial investment Pretax salvage value Cost savings per year Working capital reduction Tax rate *Depreciation straight-line over life
$720,000 $75,000 $260,000 $(110,000) 35% 5
Output area:
Annual depreciation charge Aftertax salvage value OCF Year 0 1 2 3 4 5 IRR
$144,000 $48,750 $219,400 Cash flow $(610,000) $219,400 $219,400 $219,400 $219,400 $158,150 21.65%
Chapter 10
Question 15 Input area:
Initial investment Pretax salvage value Cost savings per year Cost savings per year Working capital reduction Annual depreciation charge Aftertax salvage value Tax rate Required return *Depreciation straight-line over life
$720,000 $75,000 $300,000 $240,000 $(110,000) $144,000 $48,750 35% 20% 5
Output area:
$300,000 Year 0 1 2 3 4 5 NPV Accept/Reject Required pretax cost savings: NPV w/o OCF Required OCF OCF less dep. tax shield Cost savings
cost savings Cash flow $(610,000) 245,400 245,400 245,400 245,400 184,150 $99,281.22 Accept
$240,000 Year 0 1 2 3 4 5
cost savings Cash flow $(610,000) 206,400 206,400 206,400 206,400 145,150 $(17,352.66) Reject
($634,615.00) $212,202.38 $161,802.38 $248,926.73
Chapter 10
Question 16 Input area:
Initial fixed asset investment Initial NWC investment Annual OCF Required return *Depreciation staight-line over life
$270,000 $25,000 $(42,000) 11% 5
Output area:
NPV EAC
$(435,391.39) $(117,803.98)
Chapter 10
Question 17 Input area:
Techron I : Cost Operating costs per year Life Techron II : Cost Operating costs per year Life Both: Salvage value Tax rate Discount rate *Depreciation straight-line
$290,000 $67,000 3 $510,000 $35,000 5 $40,000 35% 10%
Output area:
Both cases: Aftertax salvage value Techron I: OCF NPV EAC Techron II: OCF NPV EAC
$26,000.00 $(9,716.67) $(294,629.73) $(118,474.97) $12,950.00 $(444,765.36) $(117,327.98)
The two milling machines have unequal lives, so they can only be compared by expressing both on an equivalent annual basis which is what the EAC method does. Thus, you prefer the Techron II because it has the lower (less negative) annual cost.
Chapter 10
Question 18 Input area:
Quantity Installation costs Pretax salvage value Fixed costs Variable production cost per carton Net working capital Tax rate Required return *Depreciation staight-line over life
185,000 $940,000 $70,000 $305,000 $9.25 $75,000 35% 12% 5
Output area:
Aftertax salvage value Depreciation tax shield Initial cash outlay NPV w/o OCF Necessary OCF OCF net of dep. tax shield Bid price
$45,500.00 $65,800.00 $(1,015,000.00) $(946,625.06) $262,603.01 $196,803.01 $12.54
Chapter 10
Question 19 Input area:
Machine cost Annual pretax cost Salvage value Inventory cost Inventory cost per year Tax rate Discount rate MACRS five year class
$560,000 $210,000 $80,000 $20,000 $3,000 35% 9% 0.2000 0.3200 0.1920 0.1152
Output area:
Year 1 2 3 4 Book value Aftertax salvage value Year 0 1 2 3 4 NPV
Depreciation $112,000 $179,200 $107,520 $64,512 $96,768.00 $85,868.80 Cash flow $(580,000.00) $172,700.00 $196,220.00 $171,132.00 $273,948.00 $69,811.79
Chapter 10
Question 20 Input area:
System A: Cost Pretax annual operating cost Life System B: Cost Pretax annual operating cost Life Both: Tax rate Discount rate *Depreciation staight-line
$430,000 $110,000 4 $570,000 $98,000 6 34% 11%
Output area:
System A: OCF NPV System B: OCF NPV
$(36,050) $(541,843.17) $(32,380) $(706,984.82)
If the system will not be replaced when it wears out, then System A should be chosen, because it has the more positive NPV.
Chapter 10
Question 21 Input area:
System A: NPV Operating life System B: NPV Operating life Discount rate
$(541,843.17) 4 $(706,984.82) 6 11%
Output area:
System A: EAC System B: EAC
$(174,650.33) $(167,114.64)
If the system is replaced, System B should be chosen because it has the lower EAC.
Chapter 10
Question 22 Input area:
Quantity Initial land cost Land opportunity cost Land value in 5 years Machine cost Pretax salvage value Fixed costs Variable cost Initial NWC Additional NWC/year Tax rate Required return *Depreciation staight-line over life
100,000,000 $2,400,000 $2,700,000 $3,200,000 $4,100,000 $540,000 $950,000 $0.005 $600,000 $50,000 34% 12% 5
Output area:
Aftertax salvage value Depreciation tax shield Initial cash outlay NPV w/o OCF Necessary OCF OCF net of dep. tax shield Bid price
$356,400.00 $278,800.00 $(7,400,000.00) $(5,079,929.11) $1,409,221.77 $1,130,421.77 $0.03163
Chapter 10
Question 23 Output area:
At a given price, taking accelerated depreciation compared to straight-line depreciation causes the NPV to be higher; similarly at a given price, lower net working capital investment requirements will cause the NPV to be higher. Thus, NPV would be zero at a lower price in this situation. In the case of a bid price, you could submit a lower price and still breakeven, or submit the higher price and make a positive NPV.
Chapter 10
Question 24 Input area:
Machine A: Cost Variable costs Fixed costs Life Machine B: Cost Variable costs Fixed costs Life Both: Sales Tax rate Discount rate *Depreciation staight-line
$2,900,000 35% $170,000 6 $5,100,000 30% $130,000 9 $10,000,000 35% 10%
Output costs area:
Variable Fixed costs Depreciation EBT Tax Net income + Dep OCF NPV EAC System B lower EAC.
Machine A $(3,500,000) (170,000) (483,333) $(4,153,333) 1,453,667 $(2,699,667) 483,333 $(2,216,333) $(12,552,709.46) ($2,882,194.74)
Machine B $(3,000,000) (130,000) (566,667) $(3,696,667) 1,293,833 $(2,402,833) 566,667 $(1,836,167) $(15,674,527.56) ($2,721,733.42)
should be chosen since it has the
Chapter 10
Question 25 Input area: Hours used per year Cost per kilowatt Return Cost Watts Lifetime hours Output area: Kilowatts used per hour Kilowatt hours per year Cost per year Expected life NPV EAC 0.06 30 $3.0300 2 $(5.76) $(3.3181) 0.015 7.50 $0.7575 24.00 $(10.31) $(1.1470) 500 $0.101 10% Traditional bulb $0.50 60 1,000 CFL $3.50 15 12,000
Chapter 10
Question 26 Input area: Hours used per year Cost per kilowatt Return Cost Watts Lifetime hours Output area: Kilowatts used per hour Kilowatt hours per year Cost per year Expected life Breakeven kilowatt/hr cost 0.060 30.00 $3.0300 2.00 $0.004509 0.015 7.50 $0.7575 24.00 500 $0.101 10% Traditional bulb $0.50 60 1,000 CFL $3.50 15 12,000
Chapter 10
Question 27 Input area: Hours used per year Cost per kilowatt Return Cost Watts Lifetime hours Output area: Kilowatts used per hour Kilowatt hours per year Cost per year Expected life Breakeven kilowatt/hr cost 0.060 30.00 $3.0300 1.00 $(0.007131) 0.015 7.50 $0.7575 24.00 500 $0.101 10% Traditional bulb $0.50 60 500 CFL $3.50 15 12,000
Chapter 10
Question 29 Input area: Car mpg Truck mpg New car mpg New truck mpg Gas price Miles per year Output area: Gallons used per year Current car New car Current truck New truck Gallons saved New car New truck 25 10 40 12.5 $3.70 12,000
480.00 300.00 1,200.00 960.00 180.00 240.00
Chapter 10
Question 31 Input area:
Original cost of land Current land value Land value in 4 years Marketing study Year 1 sales Year 2 sales Year 3 sales Year 4 sales Sales price Fixed costs Variable costs Equipment costs Pretax salvage value Net working capital Tax rate Required return Year 1 depreciation Year 2 depreciation Year 3 depreciation Year 4 depreciation
$1,400,000 $1,500,000 $1,600,000 $125,000 3,200 4,300 3,900 2,800 $780 $425,000 15% $4,200,000 $400,000 $125,000 38% 13% 33.33% 44.45% 14.81% 7.41%
Output area:
Aftertax salvage value Sale price Taxes Total
$400,000 (152,000) $248,000 Year 0 Year 1 $2,496,000 425,000 374,400 1,399,860 $296,740 112,761 $183,979 $1,583,839 Year 2 $3,354,000 425,000 503,100 1,866,900 $559,000 212,420 $346,580 $2,213,480 Year 3 $3,042,000 425,000 456,300 622,020 $1,538,680 584,698 $953,982 $1,576,002 Year 4 $2,184,000 425,000 327,600 311,220 $1,120,180 425,668 $694,512 $1,005,732 $248,000 1,600,000 125,000 $1,583,839 $2,213,480 $1,576,002 $2,978,732
Revenues Fixed costs Variable costs Depreciation
EBT
Taxes Net income OCF Capital spending Land Net working capital Total cash flow NPV $(4,200,000) (1,500,000) (125,000) $(5,825,000.00) $229,266.82
Chapter 10
Question 32 Input area:
Year 1 unit sales Year 2 unit sales Year 3 unit sales Year 4 unit sales Year 5 unit sales Initial NWC Additional NWC/year Fixed costs Variable cost per unit Unit price Equipment cost Salvage value (% of price) Tax rate Required return MACRS depreciation
93,000 105,000 128,000 134,000 87,000 $1,800,000 15% $1,200,000 $265 $380 $24,000,000 20% 35% 18% 14.29% 24.49% 17.49% 12.49% 8.93%
Output area:
Year Ending book value Sales Variable costs Fixed costs Depreciation EBIT Taxes Net income Depreciation Operating cash flow Net cash flows Operating cash flow Change in NWC Capital spending Total cash flow Net present value Internal rate of return
0
1 $20,570,400 $35,340,000 24,645,000 1,200,000 3,429,600 $6,065,400 2,122,890 $3,942,510 3,429,600 $7,372,110
2 $14,692,800 $39,900,000 27,825,000 1,200,000 5,877,600 $4,997,400 1,749,090 $3,248,310 5,877,600 $9,125,910
3 $10,495,200 $48,640,000 33,920,000 1,200,000 4,197,600 $9,322,400 3,262,840 $6,059,560 4,197,600 $10,257,160
4 $7,497,600 $50,920,000 35,510,000 1,200,000 2,997,600 $11,212,400 3,924,340 $7,288,060 2,997,600 $10,285,660
5 $5,354,400 $33,060,000 23,055,000 1,200,000 2,143,200 $6,661,800 2,331,630 $4,330,170 2,143,200 $6,473,370
$(1,800,000) (24,000,000) $(25,800,000) $3,851,952.23 23.62%
$7,372,110 (684,000) $6,688,110
$9,125,910 (1,311,000) $7,814,910
$10,257,160 (342,000) $9,915,160
$10,285,660 2,679,000 $12,964,660
$6,473,370 1,458,000 4,994,040 $12,925,410
Chapter 10
Question 33 Input area:
Installed cost Salvage value Initial NWC Tax rate Required return MACRS
$610,000 $40,000 $55,000 35% 12% 33.33% 44.45% 14.81% 7.41%
Output area:
Aftertax salvage value Year 1 depreciation Year 2 depreciation Year 3 depreciation Year 4 depreciation Year 1 depreciation CF Year 2 depreciation CF Year 3 depreciation CF Year 4 depreciation CF Initial cash outlay NPV net of OCF Pretax cost savings
$26,000.00 $203,313.00 $271,145.00 $90,341.00 $45,201.00 $71,159.55 $94,900.75 $31,619.35 $15,820.35 $(665,000.00) $(447,288.67) $190,895.74
Chapter 10
Question 34 Input area:
Quantity Installation costs Pretax salvage value Fixed costs Variable production cost per carton Net working capital Tax rate Required return *Depreciation straight-line over life Price per carton
185,000 $940,000 $70,000 $305,000 $9.25 $75,000 35% 12% 5 $13.00
Output area:
Aftertax salvage value a. Year Sales Variable costs Fixed costs Depreciation EBIT Taxes Net income Depreciation Operating cash flow Net cash flows Operating cash flow Change in NWC Capital spending Total cash flow Net present value b. NPV w/o OCF Necessary OCF Breakeven quantity Year Sales Variable costs Fixed costs Depreciation EBIT Taxes Net income Depreciation Operating cash flow Net cash flows Operating cash flow Change in NWC Capital spending Total cash flow Net present value c. NPV w/o OCF Necessary OCF Breakeven fixed costs Year Sales Variable costs Fixed costs Depreciation EBIT Taxes Net income Depreciation Operating cash flow Net cash flows Operating cash flow Change in NWC Capital spending Total cash flow Net present value 0
$45,500 1 $2,405,000 1,711,250 305,000 188,000 200,750 70,263 130,488 188,000 $318,488 2 $2,405,000 1,711,250 305,000 188,000 200,750 70,263 130,488 188,000 $318,488 3 $2,405,000 1,711,250 305,000 188,000 200,750 70,263 130,488 188,000 $318,488 4 $2,405,000 1,711,250 305,000 188,000 200,750 70,263 130,488 188,000 $318,488 5 $2,405,000 1,711,250 305,000 188,000 200,750 70,263 130,488 188,000 $318,488
$(75,000) (940,000) $(1,015,000) $201,451.10 $(946,625.06) $262,603.01 162,073 0
$318,488 $318,488
$318,488 $318,488
$318,488 $318,488
$318,488 $318,488
$318,488 75,000 45,500 $438,988
1 $2,106,949 1,499,176 305,000 188,000 114,774 40,171 74,603 188,000 $262,603
2 $2,106,949 1,499,176 305,000 188,000 114,774 40,171 74,603 188,000 $262,603
3 $2,106,949 1,499,176 305,000 188,000 114,774 40,171 74,603 188,000 $262,603
4 $2,106,949 1,499,176 305,000 188,000 114,774 40,171 74,603 188,000 $262,603
5 $2,106,949 1,499,176 305,000 188,000 114,774 40,171 74,603 188,000 $262,603
$(75,000) (940,000) $(1,015,000) $$(946,625.06) $262,603.01 $390,976.15 0
$262,603 $262,603
$262,603 $262,603
$262,603 $262,603
$262,603 $262,603
$262,603 75,000 45,500 $383,103
1 $2,405,000 1,711,250 390,976 188,000 114,774 40,171 74,603 188,000 $262,603
2 $2,405,000 1,711,250 390,976 188,000 114,774 40,171 74,603 188,000 $262,603
3 $2,405,000 1,711,250 390,976 188,000 114,774 40,171 74,603 188,000 $262,603
4 $2,405,000 1,711,250 390,976 188,000 114,774 40,171 74,603 188,000 $262,603
5 $2,405,000 1,711,250 390,976 188,000 114,774 40,171 74,603 188,000 $262,603
$(75,000) (940,000) $(1,015,000) $-
$262,603 $262,603
$262,603 $262,603
$262,603 $262,603
$262,603 $262,603
$262,603 75,000 45,500 $383,103
Chapter 10
Question 35 Input area:
Contract quantity Equipment Net working capital Salvage value Fixed costs Variable costs/unit Mkt. sales in Year 1 Mkt. sales in Year 2 Mkt. sales in Year 3 Mkt. sales in Year 4 Market price Tax rate Required return Project NPV
17,500 $3,400,000 $95,000 $275,000 $600,000 $175 3,000 6,000 8,000 5,000 $285 40% 13% $100,000
Output area:
Market sales Sales Variable costs EBT Tax Net income (and OCF) NPV of market sales Initial investment Aftertax salvage value NPV of OCF OCF Bid price
1 $855,000 525,000 $330,000 132,000 $198,000 $1,053,672.99 $3,495,000 $165,000 $2,381,864.14 $800,768.90 $253.17
2 $1,710,000 1,050,000 $660,000 264,000 $396,000
3 $2,280,000 1,400,000 $880,000 352,000 $528,000
4 $1,425,000 875,000 $550,000 220,000 $330,000
Chapter 10
Question 36 Input Area:
Old cost New machine cost Life of machine Salvage value Old machine depreciation Old machine life left MV old machine Old machine value in 2 yrs Saved operating costs Discount rate Tax rate
$650,000 $780,000 5 $150,000 $130,000 3 $210,000 $60,000 $145,000 12% 38%
Output Area:
a. New computer: Year Ending book value Cost savings Depreciation Operating CF Change in NWC Capital spending Total cash flow Net present value EAC Old Computer: Year Ending book value Depreciation tax shield Change in NWC Capital spending Total cash flow Net present value EAC b. Difference: New computer Old computer Total cash flow NPV
0 $780,000
1 $624,000 $89,900 $59,280 $149,180
2 $468,000 $89,900 $59,280 $149,180 0 0 $149,180
3 $312,000 $89,900 $59,280 $149,180 0 0 $149,180
4 $156,000 $89,900 $59,280 $149,180 0 0 $149,180
5 $$89,900 $59,280 $149,180 0 $93,000 $242,180
0 $(780,000) $(780,000) $(189,468.79) $(52,560.49)
0 0 $149,180
0
1 $260,000 $49,400 0 0 $49,400
2 $130,000 $49,400 0 $86,600 $136,000
3
4
5
0 $(377,200) $(377,200) $(224,674.49) $(132,939.47)
$(780,000) $377,200 $(402,800) $35,205.70
$149,180 ($49,400) $99,780
$149,180 $(136,000) $13,180
$149,180 $$149,180
$149,180 $$149,180
$242,180 $$242,180
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more.
Course Hero has millions of course specific materials providing students with the best way to expand
their education.
Below is a small sample set of documents:
Below is a small sample set of documents:
American Jewish University - BT - 1003
Chapter 11Problems 1-32Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 12Problems 1-24Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 13Problems 1-28Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 14Problems 1-26Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 15Problems 1-15Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in greenNOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 16Problems 1-22Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in greenNOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 17Problems 1-16Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in greenNOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 18Problems 1-18Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in greenNOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 19Problems 1-12, Appendix 1-10Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in greenNOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be install
American Jewish University - BT - 1003
Chapter 20Question 16 Input Area:Sales Cost per unit Probablity of default Initial charge to subscribe Cost of each credit report500 $490 4% $450 $5.00Output Area:Cost of subscription Savings from credit reports Net savings$2,950.00 $9,800.00 $6,850
American Jewish University - BT - 1003
Chapter 24Problems 1-22Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in greenNOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To
American Jewish University - BT - 1003
Chapter 26Question 15 Input Area: Foxy Price-earnings ratio Shares outstanding Earnings Dividends Analyst growth rate Management growth rate c. Cash offer e. Shares offered g. Consultant growth rate Output Area: a. Pulitzer EPS Pulitzer stock price Pulit
American Jewish University - BT - 1003
Chapter 25Problems 1-30Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in greenNOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To
Bilkent University - ENG - 101
STRESS AND HEALTHIn a challenging condition, personal appraisals come to be the critical factors to determine the psychological consequences of the situation i.e. the measure of the stress. Creating pessimistic thoughts can easily get the psychostasis eq
University of Toronto - MATH - 223
University of Toronto Department of Mathematics MAT223H1F Linear Algebra I Midterm Examination October 22, 2009 H. Kim, S. Kudla, F. Murnaghan, S. Uppal Duration: 1 hour 50 minutesLast Name: Given Name: Student Number: Tutorial Code:No calculators or ot
Essex County College - ECONOMICS - 101
Ronald Francois 10/20/2008 Chapt 3 Pg 65 1) About 90% of the world population (including 60 % in China and India alone) is outside of the borders and make up the global market, so the potential customer base is vast. 2) The Comparative advantage theory st
Essex County College - ECONOMICS - 101
Ronald Francois 10/24/2008 Chapt 4 Pg 94 1) Ethics are defined as the standards of moral behavior, that is, behavior that is accepted by society as right versus wrong. 2) Ethics reflects people's proper relations with one another. Legality is more limitin
Essex County College - ECONOMICS - 101
Ron Francois 10/17/2008 Chapt 6 Pg 159 1. People are will to take the risk of entreprenuership for many reasons; some of which include the Lure and Opportunity to realize ones dreams and to Profit from its progress, and also the independence and challenge
Essex County College - ECONOMICS - 101
Ron Francois 10/17/2008 Chapt 7 Pg 184 1) Management today focus more on guiding, teaching, and supporting their employees as oppose to just telling them what to do. 2) Management means the process used to accomplish organizational goals through planning,
Essex County College - ECONOMICS - 101
Ronald Francois 10/17/2008 Chapt 8 Pg 211 1) The term division of labor means to divid the various functions of a job to different employees but specialization rfers to dividing the task to different employees and placing and emphasis on which task each p
Essex County College - ECONOMICS - 101
Ron Francois 10/31/08 Chapt 10 Pg 267 1) There some similarities and differences between Maslow and Taylor's studies. Mayo's study moved management theory away from Taylor's scientific management and toward theories that stress human factors of motivation
Essex County College - ECONOMICS - 101
Ronald Francois 10/31/08 Chapt 11 Pg 296 1) Human source management is the process of determining human resource needs and then recruiting, selecting, developing, motivating, evaluating, compensating and scheduling employees to achieve organizational goal
Essex County College - ECONOMICS - 101
Ron Francois 11/14/08 Chapt 12 Pg 336 1) The major laws affecting union growth were: 1) Norris-LaGuardia Act, 1932-Prohibited courts from issuing injunctions against nonviolent union activities, 2) National Labor Relations Act (Wagner Act), 1935- Gave emp
Essex County College - ECONOMICS - 101
Ron Francois 11/14/08 Chapt 13 Pg 356 1) The three parts of the marketing concept are: 1) a customer orientation, 2) a service orientation, and, 3) a profit orientation (that is, market those goods and services that will earn the firm a profit and enable
Essex County College - ECONOMICS - 101
Framework (concept and principles) 1. 2. 3. 4. 5. Accounting (n) is a service activity. Potential owners are among the external users (f) of financial statements. Managerial (t) accounting systems are primarily designed for internal users. A balance sheet
Essex County College - ECONOMICS - 101
(LO 7) E5-13 (Statement of Cash Flows-Classifications) A. B. C. D. E. F. G. H. I. J. K. L. M. income Issuance of capital stock. (4) Financing activity Purchase of land and building. (3) Investing activity Redemption of bonds. (4) Financing activity Sale o
Essex County College - ECONOMICS - 101
E 1-3 (Page 39) 1. Accounting Principles Board e. APBOs 2. Financial Accounting Standards Board a. Statement of Financial Accounting Concepts d. Statement of Financial Accounting Standards g. Technical Bulletins 3. Securities and Exchange Commission b. Fi
Essex County College - ECONOMICS - 101
Vosburgh Electronics CorporationBalance SheetDecember 31, 2009AssetsCurrent assets: Cash Short-term investment Recievables Less: Allowance for uncollectible Accounts Note recievable Interest receivables Nontrade recievables Inventories Prepaid expense
Essex County College - ECONOMICS - 101
General Lighting CorporationIncome StatementDecember 2007 Revenue from Operations: Less: Cost of Goods sold Gross profit Operating Expenses: Salaries expense Rent expense Depreciation expense Loss from Write-down of inventory -due to obsolescence Total
Essex County College - ECONOMICS - 101
Rembrandt Paint Company Combine statement of Income and Comprehensive Income statement For fiscal year End Dec, 31, 2009 (000s) Revenue from Operations: Net sales Less: Cost of Goods sold Gross profit Operating Expenses: Selling and administrative expense
Essex County College - ECONOMICS - 101
Duke CompanyCombine statement of Income and Comprehensive Income statementFor fiscal year End Dec, 31, 2009 Revenue from Operations: Sales Less: Cost of Goods sold Gross profit Operating Expenses: Selling expenses General and administrative expenses Res
Essex County College - ECONOMICS - 101
E 1-9 1. Pastel Paint Company is in direct violation of the Historical Cost Principle, which states that asset and liability measurements should be based on original cost or payment in the exchange transaction. 2. Atwell Corporation has violated the perio
Essex County College - ECONOMICS - 101
BRECKER INC.State of Cash flowfor fiscal year end December 31, 2008 Cash flow from operating activities: Cash recieved from customers Deduct cash payments for purchases: Cost of goods sold Operating expense Interest expense Income tax expense Net cash f
Essex County College - ECONOMICS - 101
John Nalezny CorporationIncome StatementDecember 2007 Revenue from Operations: Sales Investment revenue Less: Cost of Goods sold Gross profit Operating Expenses: Selling expense Administrative expense Interest expense Total operating expenses Income (ne
Essex County College - ECONOMICS - 101
John Nalezny CorporationBalance SheetDecember 31, 2007AssetsCurrent assets: Cash Short-term investment Recievables Less: Allowance for uncollectible Accounts Inventories Total current assets Investments in Stocks Investments in Bonds Property, plant,
Essex County College - ECONOMICS - 101
John Nalezny CorporationBalance SheetDecember 31, 2007AssetsCurrent assets: Cash Short-term investment Recievables Less: Allowance for uncollectible Accounts Inventories Total current assets Investments in Stocks Investments in Bonds Property, plant,
Essex County College - ECONOMICS - 101
o Include restructuring costs of $800 under operating expenses. 500,000 shares of common stock were outstanding throughout 2009. Add a discontinued section listing loss from operation of $1.6 million. Include a gain on disposal of asset of $2 million. I
Essex County College - ECONOMICS - 101
2009 Contract price Construction costs: Construction costing incurred during the year Construction costing incurred in prior years Cumulative construction costs Estimated costs to complete at end of year Total estimated and actual construction costs Total
Essex County College - ECONOMICS - 101
Include Restructing Cost item under Operating expense section $300,000. Add an Extraordinary item section listing Loss from Operations of $3,000,000 less incometax benefit; also include a Gain on expropriated asset for $1,000,000 less income tax expens
Essex County College - ECONOMICS - 101
Ronald Francios1A 1 2 3 4 5 6 7 8 9 North South East Total AverageBCE F Jake's Gym Second Quarter Membership Sales Sales by Region June 18,150 19,093 28,640 65,883 21,961 Total 49,650 52,231 78,347 180,228 60,076 Average 16,550 17,410 26,116DGHI
Essex County College - ECONOMICS - 101
West Transylvania Athletics Grade Book - Final Semester Averages Test Average 76.3 95.3 76.8 63.8 86.5 85.0 57.3 76.3 87.5 74.8 80.8 89.0 79.3 63.8 HW Bonus Semester AverageName Albert, Eddy Thomas, Frank Jones, Theodore Fagan, Samuel Dicks, Starr Frampt
Essex County College - ECONOMICS - 101
Duke Real Estate Monthly Sales2/13/2012 Property 831 Berkley Rd 310 Montery Rd 1130 conway Dr 1430 Colony Dr 1449 Point St 761 Ridge Ave 206 Fenton St 1910 Denton Ave Totals Commission % Ron Francois Size (sq ft) 1200 2500 3600 4500 3500 3000 2250 1200 L
Essex County College - ECONOMICS - 101
Greater Latrobe School District The Special Collection ExhibitionTitle Artist Acquired 1936 1939 1940 1940 1940 1940 1940 1941 1941 1947 1948 1956 1957 1957 Blossom Time Morgan The Golden Triangle Way Leona Ament The Junior choir Fletcher Tulips Johnston
Essex County College - ECONOMICS - 101
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28BCDE F Smithtown Hospital Radiology Department PayrollGHIJKHourly Regular Overtime Withholding Soc Sec Name Wage Hours Hours Gross Pay Tax Tax Net Pay Dwyer $8.00 40 8 $
Essex County College - ECONOMICS - 101
West Transylvania Athletics Grade Book - Final Semester Averages Test Average 76.3 95.3 76.8 63.8 86.5 85.0 57.3 76.3 87.5 74.8 80.8 89.0 79.3 63.8 HW BonusName Albert, Eddy Thomas, Frank Jones, Theodore Fagan, Samuel Dicks, Starr Frampton, Judy Marie, T
Essex County College - ECONOMICS - 101
A 1 2 3 Accrual Phase 4 Annual Salary 5 Employee contribution Employer contribution 6 7 Total contribution Interest Rate 8 Years contributing 9 10 Future Value 11BCDECalculating Your Retirement$60,000 6.20% 6.20% $7,440 6% 45 $1,582,812 Pension Phas
Culinary Institute of Virginia - ECON - 101
Haydn Woodall Nicholas Kristof penned the article "The Face of Modern Slavery" on November 16 of 2011, an extremely emotional editorial which asserts the importance of combatting the network of modern sex slave trading through his passionate tone and stri
Culinary Institute of Virginia - ECON - 101
Haydn Woodall Prcis #1 Nicholas Kristof penned the article "The Face of Modern Slavery" on November 16 of 2011, an extremely emotional editorial which asserts the importance of combatting the network of modern sex slave trading through his passionate tone
Culinary Institute of Virginia - ECON - 101
Domestic Policy o The Alien and Sedition Acts, in response to the possibility of an open war with France, severely limited American freedom in a time of crisis o the patriarchal family a male head, wife, and children everyone worked at home, generally on
Michigan - EECS - 203
EECS 203 Fall 2010Midterm Exam 1 (70 points)Closed Book Closed Electronic Devices Closed Neighbor One side of one sheet of an 8.5 x 11 paper is allowed as a cheat sheet.Name: Sample Solution UM unique name: Discussion section: (circle)Benjamin(Fri 1:3
Michigan - EECS - 203
EECS 203 Fall 2010Midterm Exam 2 (75 points)Closed Book Closed Electronic Devices Closed Neighbor Two 8.5 x 11 pages are allowed as cheat sheets.Name: Sample Solution UM unique name: Discussion section: (circle)Benjamin(Fri 1:30-2:30) Benjamin(Fri 2:3
Michigan - EECS - 203
EECS 203 Fall 2010Midterm Exam 1 (70 points)Closed Book Closed Electronic Devices Closed Neighbor One side of one sheet of an 8.5 x 11 paper is allowed as a cheat sheet.Name: UM unique name: Discussion section: (circle)Benjamin(Fri 1:30-2:30) Benjamin
Michigan - EECS - 203
EECS 203 Fall 2010Midterm Exam 2 (75 points)Closed Book Closed Electronic Devices Closed Neighbor Two 8.5 x 11 pages are allowed as cheat sheets.Name: UM unique name: Discussion section: (circle)Benjamin(Fri 1:30-2:30) Benjamin(Fri 2:30-3:30) Kuldeep(
Michigan - EECS - 203
EECS 203: Homework 1 SolutionsSection 1.1 1. (E) 8bef b) You do not miss the final exam if and only if you pass the course. e) If you have the flu then you do not pass the course, or if you miss the final examination then you do not pass the course. f) Y
Michigan - EECS - 203
EECS 203: Homework 1 SolutionsSection 1.1 1. (E) 8bef b) You do not miss the final exam if and only if you pass the course. e) It is either the case that if you have the flu then you do not pass the course or the case that if you miss the final exam then
Michigan - EECS - 203
EECS 203: Homework 2 SolutionsSection 1.5 1. (E) 4bd b) Disjunctive syllogism. d) Addition. 2. (M) 14bd b) Let r(x) = "r is one of the five roommates listed", d(x) = "x has taken a course in discrete mathematics", a(x) = "x can take a course in algorithm
Michigan - EECS - 203
EECS 203 Homework 2Section 1.31. (E) 6bef and 10cde 6a) Every student in school has visited North Dakota 6b) Not every student in the school has visited North Dakota 6c) No student in the school has visited North Dakota 10c) x(C(x) F (x) D(x) 10d) x(C(x
Michigan - EECS - 203
EECS 203: Homework 3 SolutionsSection 2.1 1. (E) 8defg d) True e) True f) True g) False, since cfw_, cfw_ = cfw_. 2. (E) 22 a) No, since a power set should contains at least the empty set ; note that P () = cfw_. b) Yes, P (cfw_a) = cfw_, cfw_a. c) No, s
Michigan - EECS - 203
EECS 203 Homework 3 SolutionsSection 1.6 6. and(an odd number) 24. Proof by contradiction: Assume that at most two days are selected from any month and still select as least 25 days. To select as many days as possible, we can select two from each month.
Michigan - EECS - 203
EECS 203: Homework 4 SolutionsSection 2.4 1. (E) 4cd c) a0 = 8, a1 = 11, a2 = 23, a3 = 71 d) a0 = 2, a1 = 0, a2 = 8, a3 = 0 2. (E) 10ef e) The general formula for this sequence is an = (3 an-1 ) + 2, given that a0 = 0 Therefore, this sequence from n=0 to
Michigan - EECS - 203
EECS 203 HOMEWORK 4 SOLUTIONS 1. (M) Prove that the union of all elements of a power set of a set is the set itself.Let S be the original set and P(S) be the power set and UPS be the union of all elements of a power set. To Prove: S = UPS We p