Skip to main content
Question

R&D Capitalization Schedule

  • June 4, 2024
  • 1 reply
  • 295 views

Forum|alt.badge.img+4

Hi All, 

I am trying to create a R&D cost Capitalization schedule and need some help. Essentially which I am trying to do is spread the cost over 3 years but then add the incremental monthly amount as well. For example: If Jan 2024, my R&D cost is $1200 and  $2400 for Feb, then I should see $100 (1200 / 12) for Jan 2024 till Dec 2024 and for Feb cost, it should be $300 ($2400/12 + 100).

 

I hope i am clear in my ask. Thanks

1 reply

CDALMAY
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • June 6, 2024

Hi @Rahul Kumar,

Does this match what you are expecting ?

SPREAD('Capitalization Input',Month,12)