50.1K

Verified Solution

Link Copied!

JUST RIGHT TRUE OR FALSE THEN EXPLAIN WHY IT IS RIGHT OR WRONG BASED ON THE ILLUSTRATION.

Instruction: a. For item 1 to 6, write T if the answer is TRUE; F if the answer is FALSE. b. For item 7 to 20, write the letter corresponding to the correct answer for each item. 1 5) In the example shown below, cell B2 uses an Excel formula. 12 Months per Year 10000 --PMT(02/12,81,831 1 Loan Term 2 Interest Rate 3 Initial Value 4 Payment 5 6 Month 7 January 8 February 9 March 10 April 11 May 12 June 13 NY 14 August 15 September 16 October 17 November 18 December 19 Payment -5854 SBS4 -5854 5854 -5854 Interest Charged -8312/12 07*$0$2/12 -085852/12 -095852/12 -010*$8$2/12 011'58$2/12 -0125852/12 -1358$2/12 014"$8$2/12 -015$&$2/12 016*$B$2/12 -01758$2/12 New Balance -33.87-07 07.08-08 -08.89-09 -09-B10-010 2010-011-C11 011.812-C12 -0124813-C13 -013-314-C14 D14 B15 C15 -015-016-C16 0164B17-C17 017-818-C18 -$B$4 -5854 -5854 -SB$4 -$854 SB54 Instruction: a. For item 1 to 6, write T if the answer is TRUE; F if the answer is FALSE. b. For item 7 to 20, write the letter corresponding to the correct answer for each item. 1 5) In the example shown below, cell B2 uses an Excel formula. 12 Months per Year 10000 --PMT(02/12,81,831 1 Loan Term 2 Interest Rate 3 Initial Value 4 Payment 5 6 Month 7 January 8 February 9 March 10 April 11 May 12 June 13 NY 14 August 15 September 16 October 17 November 18 December 19 Payment -5854 SBS4 -5854 5854 -5854 Interest Charged -8312/12 07*$0$2/12 -085852/12 -095852/12 -010*$8$2/12 011'58$2/12 -0125852/12 -1358$2/12 014"$8$2/12 -015$&$2/12 016*$B$2/12 -01758$2/12 New Balance -33.87-07 07.08-08 -08.89-09 -09-B10-010 2010-011-C11 011.812-C12 -0124813-C13 -013-314-C14 D14 B15 C15 -015-016-C16 0164B17-C17 017-818-C18 -$B$4 -5854 -5854 -SB$4 -$854 SB54

Answer & Explanation Solved by verified expert

See Answer