Questions tagged [spreadsheet]

For questions regarding the use of spreadsheet programs (such as MS Excel, Google Sheets, OpenOffice Calc, etc.) in personal finance, including questions about spreadsheet financial functions.

Filter by
Sorted by
Tagged with
0
votes
0answers
66 views

How do I solve this in excel? I think it's a cumulative rolling percentage problem

I have a spreadsheet that shows the following columns. Date, Loan Applications Received, Interest Rate Offered, Cumulative Applications Received, Loans Originated, Average Interest Rate on ...
0
votes
0answers
231 views

Sensitivity Table for IRR Using Purchase Price & Total Synergies

For my DCF I have a line for Synergies to be entered for each of four years How can I create a sensitivity table in Excel for IRR taking into variations in purchase price (enterprise value) and total ...
-1
votes
1answer
164 views

Is it possible to import bulk historical prices from yahoo or google into Excel and calculate 2STD?

I believe a version of this question has been asked before. However, I'm not sure if what I am trying to accomplish can be done. I am trying to import into Excel at the end of each day all of the the ...

1
2