can you solve this for me in a spreadsheet format and provide the detailed steps with formulas and the relevant answers on how it was solved

A company receives an invoice of $100\mathrm{.}000$ with payment conditions

$2/10/60.$

$60$ days from now, a $1-$year deposit ends. The principal of this deposit is $130\mathrm{.}000,$ and the simple interest is $7\%.$ As described in the contract of this deposit, there is a $1\%$ penalty of the principal if repayment is asked before the due date

Additional information: interest rate for short term loans is $10\%,$ for short term deposits is $3\%.$

The most obvious strategy is to wait $60$ days and use the repayment of the deposit to pay the invoice, But is this the optimal solution?

Input data

Invoice

$$

$100,000\mathrm{.}00$

Discount

$\%$

$2\%$

When

days

$10$

Nett

days

$60$

$1$yr Deposit, remaining

days

$60$

$1$yr Deposit, term

year

$1$

$1$yr Deposit, amount

$$

$130,000\mathrm{.}00$

$1$yr Deposit, penalty

$$

$1,300\mathrm{.}00$

$1$yr Deposit, interest rate

$\%$

$7\%$

Rate short term loan

$\%$

$10\%$

Rate short term deposit

$\%$

$3\%$

Days$/$year

days

$365$

Solution