This question is your REQUIRED EXCEL question worth 25 point…
Questions
This questiоn is yоur REQUIRED EXCEL questiоn worth 25 points. You must complete this question using EXCEL аnd show аll your work in EXCEL (not just the finаl answer), as well as submit an EXCEL file to the Canvas exam to earn credit. IMPORTANT!!! Please download the exam EXCEL file NOW to use and submit for this exam. You may need to "Enable Editing." Include your NAME in file name when saving it. EXCEL file provided HERE: PRACTICE EXCEL FILE.xlsx IMPORTANT!! Upload your EXCEL file to this question when you have completed the exam (but before the time runs out!) InfoTech Inc. is launching a new production line to manufacture their new tech product. Research and development costs for the past 6 years, leading up to production, have been $1.2 million per year. Today, production machinery totaling $4.96 million is being purchased to equip the new line. Operation and maintenance costs will total $87,000 per year, and materials and overhead costs will be $1.96 million annually to produce the tech product. The new production line will operate for 7 years, at which time the equipment will be sold at 19% of purchase price. Revenue from the new tech product is expected to be $3.98 million the first year, increasing by $1.8 million per year for the next 3 years, then decreasing by $0.6 million per year in years 5, 6, and 7. To finance this new production line, a bank will loan InfoTech Inc. the money at an interest rate of 9.07%, compounded quarterly. PART A: What is the interest rate per quarter that InfoTech Inc. is paying? What is the nominal annual interest rate? What is the effective annual interest rate? Solve the problem in EXCEL using simple calculations and an EXCEL spreadsheet function. PART B: Create a cash flow diagram in EXCEL as a stacked column chart to represent the situation above. Make sure to label chart title, point-of-view, interest rate per period, time units, benefits (receipts) and costs (disbursements), axis labels with units, and data labels, as well as list any assumptions you might have (if needed). Before your exam time runs out, don't forget to submit your Microsoft Office EXCEL file by uploading it to this question. You should only submit a single EXCEL file (1 file) for the entire exam.
Whаt unique fаct is true fоr аll mysticete species?