Description
I want you do homework excel
you must do in excel in attachment and instruction in PDF
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hi there. Find the solutions attached. Solved expertly.
Loan Amount
175,000
Term In Months
360
Interest Rate
0.050984999
Payment
$950.00 =-PMT(B3/12,B2,B1)
From the question, Loan needed is 175,000
Term is 30*12=360 days
Procedure
1. Select the cell containing the formula. (B4)
2. From Data tab, click what-if analysis and and select Go-s
3. From dialog box, -fill 'Set cell' with sele...