Question: Please help me solve question J. Excel data provided in the second image: To launch online sales, B-Trendz will need to hire a website development
Please help me solve question J. Excel data provided in the second image:

To launch online sales, B-Trendz will need to hire a website development company to set up and maintain the website. To do so, B-Trendz will need to take out a loan to cover the cost of the development and maintenance of the website. You have solicited and received bids from three different companies. For each bid, you need to determine the monthly payment, total loan payment, and total interest. Select the Online worksheet. In cell B11, calculate the monthly payment for the loan given the loan amount, term, and interest for the Online Solutions company. The result should be a positive value. In cell B12, calculate the total payments over the life of the loan. In B13, calculate how much total interest will be paid over the life of the loan. Copy the range B11:B13 to D11:013. You need to recommend which company B-Trendz should use to create and maintain the online website. The best option is based on the company maintaining the website for at least two years and a monthly payment of $2,100 or less. Use a logical function in cell B15:D15 to return the company name from row 2 if the website will be main- tained for at least two years and the monthly payment is $2,100 or less. If the value is false, the cell should remain blank. liations Insert Company Options Service/Product Maintains website Cost Online Solutions Online For You Creative Development Designs website for Designs website for Designs website for online product sales online product sales online product sales 1 2 3 $ 100,000.00 $ 110,000.00 $ 120,000.00 5 5.05% 5 5.05% 5 5.05% Loan Options Term in Years Interest Monthly Payment Total Loan Payment Total Interest Best Option
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
