I need an automatic foreign currency converter in cel C33. A pull down option to choose different currencies would be useful. Default to USD/CAN ($1USD = Pulldown: ie CAN). Use today’s date above if you need to (Cell C32). After this cell is done, use it to adjust cell C35 (rather then my manual entry). Also use it to adjust Cell C36 (as we raise in USD).
Notice Cell C42. This should start at zero then increase based on the expenses budget (and paid) for the preceding month. Use the time stamp to determine month. So no cash will be used for April of this year. But the following month (May), you would have used the expenses in the previous month ((M60), the add cumulative months as they past the 1st of every month. This is all about total expenses. Adjust quarterly for budget/actual variances.
Payroll lead time (A41). “how many months of payroll coverage do we have in terms of months?” round to 2 decimals (4.4 months). Means cash on hand / total monthly payroll (total expenses - other expenses) or row 59.
Cel 41. is next months expenses based on the timestamp.