Analyzing new deals

[Goanar Mar]

As a new investor one thing I think that will help me that was recently introduced to me by another investor is a spreadsheet that can analyze potential deals for me. For example being able to input different numbers such as expenses, down payment, rent, or etc. Then having the program automatically calculate the numbers inputted to give me back what the coc return is or what my ending balance each month should be. I have a decent idea of what some of the things for expenses and what some of the numbers should be but struggling to find other things like what current interest rates will be and the equation. Also calculating things like cap ex costs. Does anyone potentially have any helpful videos or books that helps to explain?  Or would you say I hand write it out at first to try and understand all the different expenses and calculations?