Question: Based on Robichek et al. (1965). At the beginning of month 1, Finco has $4500 in cash. At the beginning of months 1, 2, 3,
Based on Robichek et al. (1965). At the beginning of month 1, Finco has $4500 in cash. At the beginning of months 1, 2, 3, and 4, Finco receives certain revenues, after which it pays bills. (File P04_124.xlsx.) Any money left over can be invested for one month at the interest rate of 0.25% per month; for two months at 0.28% per month; for three months at 0.33% per month; or for four months at 0.37% per month. Determine an investment strategy that maximizes cash on hand at the beginning of month 5.
Step by Step Solution
3.48 Rating (161 Votes )
There are 3 Steps involved in it
Model Investment strategy Range names used CashAvail ModelB33E33 Revenues and bills ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1497_6040bb5637c4a_694772.xlsx
300 KBs Excel File
