The Table below provides a comparison of cash-flow streams for a loan repayment. The loan repayments are considered under simple and flat interest loans for five years with a discounting factor 8%. Complete the table with the appropriate discount factor to calculate the discounted value for the flat interest loan payment.

(Please include Excel formulas)

	Discount factor (8%)	Simple interest loan payment ($)	Discounted value ($)	Flat interest loan payment ($)	Discounted value ($)
Year 1		1,400		840
Year 2		1,120		840
Year 3		840		840
Year 4		560		840
ear 5		280		840

n [= 6% 7.00% 8.00% 1 0.94340 0.93458 0.92593 2 0.89000 0.87344 0.85734 3 0.83962 0.81630 0.79383 4 0.79209 0.76290 0.73503 5 0.74726 0.71299 0.68058