Loan Amount = $ 2000
Number of years = 5
Interest rate = 9%
Simple Interest = Loan amount * rate * time
= $ 2000 * 9% * 5
= $ 900
APR = ((Interest + Origination Fee)/Loan Aamount)*365/n*100
where,
n = number of days in loan term = 5*365 = 1825 days
= (($ 900 + $ 80)/ $2000) * 365/ 1825 * 100
= 9.80% p.a.
Question 16 4 pts Compute the APR of the following loan: I borrow two thousand dollars for 5 years from a lender who ch...
I just need the excel formula of C27 to C66
Question 1 (40 marks)
Refer to Table 1. Write the Excel formula for each cell
marked with “?” in column C such that formula could be copied and
pasted into columns D, and E using Microsoft Excel without further
editing. There is no need to explicitly write the Excel formula
for cells marked with “Copy & paste”. Label each formula
clearly with cell reference position.
In many country towns of...