spacenab

Spacenab

Log in

 Password
"Post your contents, writings, articles, info-graphics, and more on spacenab."
sign up with facebook
Create a new post
Mike Brown

FIN 370 Week 4 Calculating Cash Flow problem set

Mike Brown

FIN 370 Week 4 Calculating Cash Flow problem set

 https://homeworklance.com/downloads/fin-370-week-4-calculating-cash-flow-problem-set/

 

Data:
Cost of Capital (borrowing)
Cost of Automobile
Cost of additional equiment atached to tu
Tax rate
Annual Before Tax Cash flows

Project
12.00%
$200,000
$15,000
35%

Year-1

Year-2

Year-3

Year-4

Year-5

Year-6

Year-7

Year-8

$70,000

Process Area:
Cash Outflows
Cost of Equipment
Total Investment Outlays

$65,000

$60,000

$55,000

$50,000

$40,000

20.0%

Depreciaiton Rate (MACRS)

$70,000

Given in problem
Given in problem
Given in problem
Given in problem
$30,000 Given in problem

32.0%

19.2%

11.5%

11.5%

5.8%

0.0%

0.0% Given in problem

Year – 0
$215,000
$215,000

Cash Inflows:
Net Operating Cash flows
Depreciation
Earnings before interest and taxes
Taxes
Earning after taxes
Add Depreciation
Net Operating Cash flows

Year-0

Given in problem
Given in problem
Year-1

Year-2

Year-3

Year-4

Year-5

Year-6

Year-7

Year-8
Take cash flows from years 0-8 (including initial outlay)
Initial investment X depreciation rate
Cash flows minus depreciation
Earnings X tax rate
Earnings before taxes minus taxes
Add depreciation from line 21
Earning after taxes + depreciation

Pay Back Period

0

0

0

0

0

0

0

0

0
Pay Back Period divided by Net Operating Cash Flows

Discounted Operating Cash flows

Decision Criteria:
Pay Back Period
Discounted Pay Back Period
Net Present Value
Internal Rate of Return
Profitability Index

0
0

>8 Years
>8 Years

0
0
#DIV/0!

Years
Years
$0.00 = Reject
Err:523
Err:523
#DIV/0!
#DIV/0!

0
0
#DIV/0!

0
0
#DIV/0!

0
0
#DIV/0!

0
0
#DIV/0!

0
0
#DIV/0!

0
0
#DIV/0!

0
0
#DIV/0!

 

Views(23) Opinions(0) 06/12/2016 22:34:54 Report abuse
Copyright © 2014 spacenab.com . All the right reserved.