Using Excel formula, please. Thanks
ULTATech is launching a new production line to manufacture their new autonomous electric car can desien costs for the past 5 years, leading up to production, have been $1.25 million per year. Today, production machinery totaling $6.35 million is being purchased to equip the new line Operation and maintenance costs will total $85,000 per year, and materials and overhead costs will be shl 25 million annually to produce the cars, the new production line will operate for 6 years at which time the equipment will be sold at 10% of purchase price. Revenue from the new electric car is expected to be $3.fi million the first year increasing by $1.0 million per year for the next 3 years, then decreasing by $0.5 million per year in years 5 and 6. To finance this new production line, a bank will loan ULTATech the money at an interest rate of 10 2541 compounded monthly PARTA What is the interest rate per month that ULTATech 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 abovel Make sure to label chart title, point-of-view, interest rate per period. time units, receipts and disbursements, axis labels with units, and data labels as well as list any assumptions you might have if needed) ULTATech is launching a new production line to manufacture their new autonomous electric car can desien costs for the past 5 years, leading up to production, have been $1.25 million per year. Today, production machinery totaling $6.35 million is being purchased to equip the new line Operation and maintenance costs will total $85,000 per year, and materials and overhead costs will be shl 25 million annually to produce the cars, the new production line will operate for 6 years at which time the equipment will be sold at 10% of purchase price. Revenue from the new electric car is expected to be $3.fi million the first year increasing by $1.0 million per year for the next 3 years, then decreasing by $0.5 million per year in years 5 and 6. To finance this new production line, a bank will loan ULTATech the money at an interest rate of 10 2541 compounded monthly PARTA What is the interest rate per month that ULTATech 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 abovel Make sure to label chart title, point-of-view, interest rate per period. time units, receipts and disbursements, axis labels with units, and data labels as well as list any assumptions you might have if needed)
