Please help and show work thank you!!!

Bauer industries is an automobile manutacturer. Managerent is currenty evaluating a proposal to buld a plant that will manufacture ightweight trucks. Bauer plane to ise a cost of captal of 11.7% to evaluate this project. Basod on extensive research, it has prepared the incrementai free cash fow projections shown below (in mitions of dollersk: a. For this base-case scenacio, what is the NPV of the plant to manutacture lightweight trucks? b. Based on ingut from the marketing department. Bauer is uncertain about its revence forecast. In particular, management would ike to examine the sensivity of the NPV 1o the reverue assumptions. What is the NPV of this project if revenues ase 10% higher than forecast? What is the NPV it revenues are 10% lower than forecast? c. Rather than assuming that cash flows for this project are constant, management would the to explore the sensinity of its anabyis to possibie growth in revenues and opereting expensen. Specifically, management would like to astume that revenues, manufacturing expenses, and marketing expenses are as given in the table for year 1 and grow by 2% per year every year starting in year 2. Management also plans to assume that the inifial caphal expenditures (and therefore depreciation) additions to mening capital, and contruation value remain as initally speciled in the Nov on the yous, for discount rates ranging from 5% to 30\%. For what ranges of ditoount tates does the projoct have a postive NPV? a. For this base-cese scenario, what is the NPV of the plant to manufacture lightweight tucks? The NPV of the plant to manufacture lightweight trucks, based on the estmaled free cash fow is 1 . mition. (Round to two decimai places.) assumptions. What is the NPV of tis propect if revences are 10% Nigher than forecast? Wrat is the NPV if revenues are 10% lower than forecast? The NPYot this project if tevenwes are 10% Righer than forecast is 1 milion. (Round to two decimal places.) The NPY of this project if ravenues are 10s lower than forecast is \& milion. (Round to two decimal placen.) c. Rather than assuming that cash flows for this project are constant, managoment would tike to explore the senstivity of its analysis to ponsitio growe in revenues and operating expenies. Specificaly, mansgement would tke to assume that revecues, macufacturing expenses, and marketing expenses are as given in the table for year 1 and grow by 27 per year erery year starting in year 2. Management also plans to assurse that the inital capital expendiures (and therefore depreciation) add tions to working capital, and continuaten value remain as ininaly spec fied in the table. What is the NPV of thie projoct under these aharnative assumptions? How does the NPV charce if the tevenues and cperating expenses grow by 5% per year rather than by 2w? If revenues, manutocturing expenses, and marketing expenses grow by 2% per year every year starting in year 2 , tha NPV of the estimssed troe cash flow is 1 milion. (Round to two decimai places.) a. For this basecaze soenario, what is the NPV of the plant to manufachare ightiweight trucka? assumptions. What is the NPY of tha project if reverues ate 10%. higher than forocast? What is the NDV if revenues aed 10% lower than forecast? NPY an the yaxis, for discount rates rarging from 5% to 30%. For what ranges of discount rates does the projoct harve a poeitive NPY? The Nervof this project if reveriaes are 10% higher than forecast is 1 mition. (Reurd to two decimal places ) ptaces.) places.) discotirt rate on the x-axis and the NPV on the yaxis, for discount rates rarging from 5% to 30%. For what ranges of discount rates doos the projoct have a positive NPV? The NPY is positive for discount rales beiow the tRR of 4. (Round to cre decirta place,) Data table (Cick on the following icon 0 in order to copy its contents into a spreadaheet.) Bauer industries is an automobile manutacturer. Managerent is currenty evaluating a proposal to buld a plant that will manufacture ightweight trucks. Bauer plane to ise a cost of captal of 11.7% to evaluate this project. Basod on extensive research, it has prepared the incrementai free cash fow projections shown below (in mitions of dollersk: a. For this base-case scenacio, what is the NPV of the plant to manutacture lightweight trucks? b. Based on ingut from the marketing department. Bauer is uncertain about its revence forecast. In particular, management would ike to examine the sensivity of the NPV 1o the reverue assumptions. What is the NPV of this project if revenues ase 10% higher than forecast? What is the NPV it revenues are 10% lower than forecast? c. Rather than assuming that cash flows for this project are constant, management would the to explore the sensinity of its anabyis to possibie growth in revenues and opereting expensen. Specifically, management would like to astume that revenues, manufacturing expenses, and marketing expenses are as given in the table for year 1 and grow by 2% per year every year starting in year 2. Management also plans to assume that the inifial caphal expenditures (and therefore depreciation) additions to mening capital, and contruation value remain as initally speciled in the Nov on the yous, for discount rates ranging from 5% to 30\%. For what ranges of ditoount tates does the projoct have a postive NPV? a. For this base-cese scenario, what is the NPV of the plant to manufacture lightweight tucks? The NPV of the plant to manufacture lightweight trucks, based on the estmaled free cash fow is 1 . mition. (Round to two decimai places.) assumptions. What is the NPV of tis propect if revences are 10% Nigher than forecast? Wrat is the NPV if revenues are 10% lower than forecast? The NPYot this project if tevenwes are 10% Righer than forecast is 1 milion. (Round to two decimal places.) The NPY of this project if ravenues are 10s lower than forecast is \& milion. (Round to two decimal placen.) c. Rather than assuming that cash flows for this project are constant, managoment would tike to explore the senstivity of its analysis to ponsitio growe in revenues and operating expenies. Specificaly, mansgement would tke to assume that revecues, macufacturing expenses, and marketing expenses are as given in the table for year 1 and grow by 27 per year erery year starting in year 2. Management also plans to assurse that the inital capital expendiures (and therefore depreciation) add tions to working capital, and continuaten value remain as ininaly spec fied in the table. What is the NPV of thie projoct under these aharnative assumptions? How does the NPV charce if the tevenues and cperating expenses grow by 5% per year rather than by 2w? If revenues, manutocturing expenses, and marketing expenses grow by 2% per year every year starting in year 2 , tha NPV of the estimssed troe cash flow is 1 milion. (Round to two decimai places.) a. For this basecaze soenario, what is the NPV of the plant to manufachare ightiweight trucka? assumptions. What is the NPY of tha project if reverues ate 10%. higher than forocast? What is the NDV if revenues aed 10% lower than forecast? NPY an the yaxis, for discount rates rarging from 5% to 30%. For what ranges of discount rates does the projoct harve a poeitive NPY? The Nervof this project if reveriaes are 10% higher than forecast is 1 mition. (Reurd to two decimal places ) ptaces.) places.) discotirt rate on the x-axis and the NPV on the yaxis, for discount rates rarging from 5% to 30%. For what ranges of discount rates doos the projoct have a positive NPV? The NPY is positive for discount rales beiow the tRR of 4. (Round to cre decirta place,) Data table (Cick on the following icon 0 in order to copy its contents into a spreadaheet.)