Book3

xlsx

School

University of Central Florida *

*We aren’t endorsed by this school

Course

5130

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

10

Uploaded by GIRALDOD55

Report
Problem Set 1 Initial outlay = Purchase Price + Shipping Cost + Initial investment Purchase Price $ 100,000.00 Shipping Cost $ 5,000.00 Investment $ 4,000.00 Initial Outlay $ 109,000.00 A company is considering purchasing a machine for $100,000. Shipping costs would be another $5,000. The project would require an initial investment in net working capital of $4,000 which would be recouped at the end of the project. What is the project's initial outlay?
Sales $ 18,000,000.00 Operating Cost $ 9,000,000.00 Depreciation $ 4,000,000.00 Profit Before Tax $ 5,000,000.00 Tax Expense $ 2,000,000.00 Profit After Tax $ 3,000,000.00 Depreciation $ 4,000,000.00 Operating Cash Flow $ 7,000,000.00 Annual Depreciation = Cost of Equipment/Useful Life Cost of Equipmet $ 250,000.00 Useful Life 10 years Annual Depreciation $ 25,000.00 Sales $ 150,000.00 Variable Cost $ 35,000.00 Fixed Cost $ 40,000.00 Depreciation $ 25,000.00 Net Operating Income $ 50,000.00 Tax Expense @ 25% $ 12,500.00 Net After Tax $ 62,500.00 Depreciation $ 25,000.00 Operating Cash Flow $ 87,500.00 A) A project will generate sales of $18 million. The operating costs (not including depreciation) are The depreciation expense is $4 million. If the tax rate is 40%, what is the operating cash flo B) A project will generate sales of $150,000. The variable costs are $35,000 and the fixed costs are $ project will use an equipment worth $250,000 that will be depreciated on a straight-line basis to a value over a 10-year life of the project.The interest expense is estimated to be $10,000. If the tax ra what is the operating cash flow?
Problem Set 2 Sales $ 250,000.00 Cash Expense $ 80,000.00 Depreciation $ 35,000.00 Net Operating Income $ 135,000.00 Tax Expense @ 25% $ 33,750.00 Net After Taxes $ 101,250.00 Depreciation $ 35,000.00 Operating Cash Flow $ 136,250.00 Sales 140*100 $ 14,000.00 Variable Cost 35*100 $ 3,500.00 Fixes Cost $ 10,000.00 Depreciation $ 10,000.00 Net Operating Income $ (9,500.00) Tax Expense @ 25% $ (2,375.00) Net After Taxes $ (7,125.00) Depreciation $ 10,000.00 Operating Cash Flow $ 2,875.00 e $9 million. ow? C) A project will generate sales of $250,000. The tot worth $350,000 that will be depreciated on a straight-li project will require an initial investment in net working If the tax rate is 25%, $40,000. The zero book rate is 25%, D) A project will generate sales of 100 units annually and the fixed costs are $10,000. The project will use an line basis to a zero book value over a 10-year life of th
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
tal cash expenses are $80,000. The project will use an equipment ine basis to a zero book value over a 10-year life of the project. The g capital is $5,000 which will be recouped at the end of the project. , what is the operating cash flow? at a selling price of $140 each. The variable costs per unit are $35 n equipment worth $100,000 that will be depreciated on a straight- he project. If the tax rate is 25%, what is the operating cash flow?
Problem Set 3 Year 0 1 2 3 Depriciation Rates 14.29% 24.49% 17.49% Depriciation $ 35,725.00 $ 61,225.00 $ 43,725.00 Book Value $ 250,000.00 $ 214,275.00 $ 188,775.00 $ 206,275.00 Ending $ 250,000.00 $ 214,275.00 $ 153,050.00 $ 109,325.00 Sale $ 5,000.00 Sale $ 80,000.00 Book Value at Year 5 $ 55,775.00 Book Value at Year 5 $ 55,775.00 Profit $ (50,775.00) Profit $ 24,225.00 Tax Rate @ 20% $ (10,155.00) Tax Rate @ 20% $ 4,845.00 After Tax Sale Value $ 15,155.00 After Tax Sale Value $ 75,155.00 An equipment worth $250,000 is classified as a 7-year MACRS property. A A) What is the book value of this asset at the end of yea B) What is the depreciation expense in each of the year C) If the equipment can be sold for $5,000 at then end of Year 5, what is th D) If the equipment can be sold for $80,000 at then end of Year 5, what is t The MACRS allowance percentages for the 7-year asset class are as follows, commencing with 8.93%, 8.92%, 8.93%, and 4.46%.
4 5 6 7 8 12.49% 8.93% 8.92% 8.93% 4.46% $ 31,225.00 $ 22,325.00 $ 22,300.00 $ 22,325.00 $ 11,150.00 $ 218,775.00 $ 227,675.00 $ 227,700.00 $ 227,675.00 $ 238,850.00 $ 78,100.00 $ 55,775.00 $ 33,475.00 $ 11,150.00 $ - Assume a tax rate of 20%. ars 1-8? rs 1-8? he after-tax salvage value? the after-tax salvage value? h year one: 14.29%, 24.49%, 17.49%, 12.49%,
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Problem Set 4 Year 1 2 3 4 Depriciation Rates 20% 20% 20% 20% Depriciation $ 31,250.00 $ 31,250.00 $ 31,250.00 $ 31,250.00 Book Value $ 250,000.00 $ 218,750.00 $ 187,500.00 $ 156,250.00 Ending $ 218,750.00 $ 187,500.00 $ 156,250.00 $ 125,000.00 Sale $ 5,000.00 Sale $ 80,000.00 Book Value at Year 5 $ 93,750.00 Book Value at Year 5 $ 93,750.00 Profit $ (88,750.00) Profit $ (13,750.00) Tax Rate @ 20% $ (17,750.00) Tax Rate @ 20% $ (2,750.00) After Tax Sale Value $ 22,750.00 After Tax Sale Value $ 82,750.00 A company purchased an equipment worth $250,000. It will be depreciated using the straight-li rate of 20%. A) What is the book value of this asset at the end of years B) What is the depreciation expense in each of the years C) If the equipment can be sold for $5,000 at then end of Year 5, what is the D) If the equipment can be sold for $80,000 at then end of Year 5, what is the
5 6 7 8 20% 20% 20% 20% $ 31,250.00 $ 31,250.00 $ 31,250.00 $ 31,250.00 $ 125,000.00 $ 93,750.00 $ 62,500.00 $ 31,250.00 $ 93,750.00 $ 62,500.00 $ 31,250.00 $ - ine depreciation over 8 years. Assume a tax s 1-8? 1-8? e after-tax salvage value? e after-tax salvage value?
Problem S Year 1 2 3 4 5 Depriciation Rates 20% 32% 19% 12% 6% Depriciation Book Value Ending 1. Suppose that ABC Company purchased $10000 of machinery 3 years ago. The machinery is 5-year M Value if the tax ra 2. Suppose that ABC Company purchased $10000 of machinery 4 years ago. The machinery is 5-year M Value if the tax ra 3. Suppose that ABC Company purchased $10000 of machinery 5 years ago. The machinery is 5-year M Value if the tax ra The MACRS allowance percentages are as follows, commencing with
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Set 5 MACRS property. The firm is selling this equipment today for $5000. What is the After-tax Salvage ate is 30%? MACRS property. The firm is selling this equipment today for $5000. What is the After-tax Salvage ate is 30%? MACRS property. The firm is selling this equipment today for $5000. What is the After-tax Salvage ate is 30%? h year one: 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, 5.76%.