90.2K

Verified Solution

Link Copied!

Please help me with this homework? there are 5 questions and I need the steps and formula for the excel spreadsheet. Thanks a lot!

OO AutoSave OPT Homework 2 (1) A@CO. Page Layout Formulas Data Home Insert Draw Review View Developer Tell me Share Comments X le A A ale Wreo Text (ch) Paste a. Av Merge & Center Conditional Format Formatting as Table Cell Styles Insert Format Delete Sort & Filter Find & Select Analyze Data V StartDate xfx 1/5/2022 A A B D E F G H H T U v w Y Z Z AA AB AC AD 3 5 ACCT 408 Loan Calculator Loan Paramters $ Loan Amount Annual Rate Loan Period in Years Start Date of Loan 0 1. 21 3 4 10,000 5.00% 15 1/5/22! Loan Summary Monthly Payment $ Number of Payment $ Total Interest $ Total Cost of Loan $ Homeworkz is to replicate this loan calculator with the following requirements 1 Similar format (both layout and color) 2 Use name range for those four parameters 3. If monthly payment date is an weekend, change it to the next business date (i.c., nekt Monday 4 Add exception controls and validations. 5 Protect your loan calculator with a password "123' and allow users to change only those four parameters 79.08 180.00 4,234.29 14,234.29 Principal Loan Start Date id Loan Hali Plewe input dhe laten 2021 $ 12,000 $ 16,00 8 7 7 $ 74,101 $10.000 $12,001 $8,000 9 0 1 2 $ 10.000 $8,000 $6.000 $5,000 $1 $4,000 $2,000 S. $ 7022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 7097 4 5 8 7 8 9 0 0 1 2 3 3 Paymento Payment Date Beginning Balance Payment Principal Interest EndingBalance 1 2/7/22 $ 10,000.00 $ 79.08 $ 37.41 $ 41.67 $ 9,962.59 2 3/7/22 $ 9,962.59 $ 79.00 $ 37.57 $ 41.51 $ 9,925.02 3 4/5/22 $ 9,925.02 $ 79.08 $ 37.73 $ 41.355 9,887.29 4 5/5/22 $ 9,897 295 79.00 $ 37.99 $ 41.20 S 9,849.41 5 6/6/22 9,849.41 79.08 $ 38.14 S 41.04 $ 9,811.87 6 7/5/22 S 9,811 37 S 79.00 $ 38.20 S 40.68 $ 9,773.17 + 5 G Homework Ready El + 115% OO AutoSave OPT Homework 2 (1) A@CO. Page Layout Formulas Data Home Insert Draw Review View Developer Tell me Share Comments X le A A ale Wreo Text (ch) Paste a. Av Merge & Center Conditional Format Formatting as Table Cell Styles Insert Format Delete Sort & Filter Find & Select Analyze Data V StartDate xfx 1/5/2022 A A B D E F G H H T U v w Y Z Z AA AB AC AD 3 5 ACCT 408 Loan Calculator Loan Paramters $ Loan Amount Annual Rate Loan Period in Years Start Date of Loan 0 1. 21 3 4 10,000 5.00% 15 1/5/22! Loan Summary Monthly Payment $ Number of Payment $ Total Interest $ Total Cost of Loan $ Homeworkz is to replicate this loan calculator with the following requirements 1 Similar format (both layout and color) 2 Use name range for those four parameters 3. If monthly payment date is an weekend, change it to the next business date (i.c., nekt Monday 4 Add exception controls and validations. 5 Protect your loan calculator with a password "123' and allow users to change only those four parameters 79.08 180.00 4,234.29 14,234.29 Principal Loan Start Date id Loan Hali Plewe input dhe laten 2021 $ 12,000 $ 16,00 8 7 7 $ 74,101 $10.000 $12,001 $8,000 9 0 1 2 $ 10.000 $8,000 $6.000 $5,000 $1 $4,000 $2,000 S. $ 7022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 7097 4 5 8 7 8 9 0 0 1 2 3 3 Paymento Payment Date Beginning Balance Payment Principal Interest EndingBalance 1 2/7/22 $ 10,000.00 $ 79.08 $ 37.41 $ 41.67 $ 9,962.59 2 3/7/22 $ 9,962.59 $ 79.00 $ 37.57 $ 41.51 $ 9,925.02 3 4/5/22 $ 9,925.02 $ 79.08 $ 37.73 $ 41.355 9,887.29 4 5/5/22 $ 9,897 295 79.00 $ 37.99 $ 41.20 S 9,849.41 5 6/6/22 9,849.41 79.08 $ 38.14 S 41.04 $ 9,811.87 6 7/5/22 S 9,811 37 S 79.00 $ 38.20 S 40.68 $ 9,773.17 + 5 G Homework Ready El + 115%

Answer & Explanation Solved by verified expert

See Answer