Answer :
Answer:
The deposit to be made today is $27,016.84
Explanation:
The initial deposit the firm needs to deposit for its savings today can computed using financial function pv-present value.
The pv formula is given as PV(rate,nper,pmt,-fv)
rate is the return of 4.5% per year
nper is the number of years it take the savings to reach the target of amount of $75000,which is 4 years.
pmt is the periodic payment of $10000
fv is the target savings amount of $75000
Find the attached spreadsheet showing how the target savings has been computed