R&DConv - R & D Converter This spreadsheet converts R&D...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
income, the book value of assets and the book value of equity. (It can also be used to convert other intangible assets, such as human capital, into capital invested. Inputs Current year's numbers Pre-tax Operating income $3,195.00 Tax rate 40.00% Net Income $1,025.00 Book value of capital $5,256.00 Capital expenditures $655.00 $525.00 5 $1,594.00 Do not input numbers in the first column (Year). It will get automatically updated based on the input above. Year R& D Expenses -1 1026.00 -2 698.00 -3 399.00 -4 211.00 -5 89.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Output Year Unamortized portion Amortization this year Current
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/29/2012 for the course FIN 6000 taught by Professor Banko during the Fall '11 term at University of Florida.

Page1 / 3

R&DConv - R & D Converter This spreadsheet converts R&D...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online