Liam Richardson is the business manager for the Smith & Lyngate Insurance agencies in the state of Maryland. Liam is interested in increasing the number of agents in Baltimore and plans to buy an office building for the new operation. He has asked for your help in creating a loan analysis that summarizes information about the loans to cover the cost of the building.Go to the Loan Calculator worksheet. The cells in the range B6:B8 have defined names, but one is incomplete and could be confusing. Cell A2 also has a defined name, which is unnecessary for a cell that will not be used in a formula.Update the defined names in the worksheet as follows:Delete the Loan_Calculator defined name.Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows:In cell D6, start to enter a formula using the PMT function.For the rate argument, divide the Rate (cell D4) by 12 to use the monthly interest rate.For the nper argument, use the Term_in_Months (cell D5) to specify the number of periods.For the pv argument, use the Loan_Amount (cell B8) to include the present value.Liam wants to compare monthly payments for interest rates that vary from 3.95% to 5.15% and for terms of 120, 180, and 240 months. He has already set up the structure for a data table in the range A12:D25.Create a two-variable data table as follows to provide the comparison that Liam requests:In cell A12, enter a formula without using a function that references the monthly payment amount (cell D6) because Liam wants to compare the monthly payments.b.For cell B8, edit the defined name to use Loan_Amount as the name.2.In cell B8, calculate the loan amount by entering a formula without using a function that subtracts the Down_Payment from the Price. 3.Liam also wants to use defined names in other calculations to help him interpret the formulas.In the range D4:D8, create defined names based on the values in the range C4:C8.e.Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount.5.In cell D7, enter a formula without using a function that multiples the Monthly_Payment (cell D6) by the Term_in_Months (cell D5) and then subtracts the Loan_Amount (cell B8) from the result to determine the total interest.6.In cell D8, enter a formula without using a function that adds the Price (cell B6) to the Total_Interest (cell D7) to determine the total cost.b.Based on the range A12:D25, create a two-variable data table that uses the term in months (cell D5) as the row input cell and the rate (cell D4) as the column input cell.

In the word dec, you will see the rest of questions. Thank you. estimated useful life of 15 years. Suppose at the end of 15 years this plant and equipment can be salvaged for $4,090,000 (1/10th of its original cost). What will be the book value of this purchase (excluding all other Plant and Equipment) after its first year of use? Use generally accepted (FASB) accounting principles.Select: 1A-$38,446,000B-$36,810,000C-$38,173,333D-$34,356,000All of your teammates are dedicated to the project. They put in the time and effort to complete their individual assignments and to be adequately prepared for team meetings. However, this time and effort does not seem to translate into effectively sharing information. Which of the following actions is most likely to improve your team’s information sharing?Select: 1A-Make discussions during team meetings more free-form.B-Schedule more virtual team meetings.C-Share less information about each other’s assignments in order to avoid confusion.D-Structure team discussions to focus on a smaller set of key issues.One of your team members, Ted, has not been accomplishing his fair share of the work and because of this, your team’s performance is suffering. Which of the following actions would be most effective to get Ted to do his fair share?Select: 1A-Ask Ted to make a public commitment to the team at the next meeting.B-Inform your boss and ask that she talk with Ted directly about his performance.C-Ask the most senior team member to address the concern with Ted.D-Express your concerns directly to Ted before the next team meeting.If Baldwin issued 1000 shares of common stock at last year's end price, the effect on the balance sheet would be:Select: 1A-Retained earnings would increase by $63,846B-Equity would decrease by $6,385C-Equity would increase by $63,846D-Retained earnings would increase by $6,385Every time your colleague faces a dilemma she is fond of saying, "I believe some principles can’t be sacrificed for anything." She clearly favors which form of ethical guidance?Select: 1A-UniversalismB-Situational ethicsC-Virtue ethicsD-UtilitarianismYou are the lead team member of a warranty claim team within the Andrews Company. Your team has had an average year, with profits remaining generally flat. In effort to boost profits for the year, your manager suggests you postpone processing any existing claims in the 4th quarter until the new fiscal year (some claims are as high as $150,000) but he’s not sure and is open to your opinion, asking "what would you suggest?" Which of the following responses would be the most appropriate step toward making an ethical decision?Select: 1A-"Let’s just make sure we cover our tracks so internal audit doesn’t go crazy."B-"Since we won't benefit directly, let's move forward with this plan."C-"Have we done this in the past?"D-"Perhaps we should explore which stakeholders would stand to win or lose from such a decision."What is the Quick Ratio of Chester?Select: 1A-2.11B-1.19 C-4.67D-3.50Midyear on July 31st, the Chester Corporation's balance sheet reported:Total Liabilities of $51.293 millionCash of $4.020 millionTotal Assets of $82.973 millionTotal Common Stock of $2.540 million. What were the Chester Corporation's retained earnings?Select: 1A-$29.140 millionB-$34.220 millionC-$38.240 millionD-$33.160 million