Question: i posted a second picture so its clear Table 1 is an example of a Capital Budget Analysis for a 5 year project with the

 i posted a second picture so its clear Table 1 is
an example of a Capital Budget Analysis for a 5 year project
i posted a second picture so its clear

Table 1 is an example of a Capital Budget Analysis for a 5 year project with the characteristics given in the Table 2 calculations. Talle 1. Cap Ba Spreadsheet Exercle Number 1 March 11 2020 Table 2. Cap Bull Spreadsheet Exerche Number YEAR BUT LORESTACION LETI USTA 300 10 GAL 30 Anne COM $25,000 Salvarea 000 Salvar Vaholainen of Working 300 SI 50 SU 50 20 ESOTO 30 30 Tema STOLCI SkrovaloEGLEPEL SC NetFlowNCE Pe Valo NCE Total Na Pre Valid SUS SO calculations. Table 1. Cap Bud Spreadsheet Exercise Number 1 March 11 2020 Wiscount kan Tax Rates YEAR Benningens investment Flow gummi Workin Capital oral Lorrainash Flows Can R Variable costs Table 2. Cap Bud Spreadsheet Exercise Number 1 Borini Aptions Discount Rate G00W Tax Rates Project Years Dominicananvestment Flors Buildings SO Equipment 3950 Work Capital $30,000 Operatinumptions: Annual Cash Revenu 25,000 Anna Variable Cash Costs S40,000 Annual Fixed Cash COM $25,000 Endin Value Assumption Salvar. Yalno Building 570,000 Salvare Value of equipment 35,000 Return of Workin. 390,000 Operating Cash Flow Buildin SL Dep. 20. ym.) EGSPLAYS Taxes C Flow altera 50 SC SO 50 50 SO $0 SU SO SO SC SO -50 $0 SO SO 50 -50 SC 30 SC 50 au H HIS Sc Value o Guipment DAwarda Total Net Cash Flow (NCF Print Value of NCF Total Ne Preset Valur SC SC SO 50 30 SO SO 50 SU SC SC Table 1 is an example of a Capital Budget Analysis for a 5 year project with the characteristics given in the Table 2 calculations. Talle 1. Cap Ba Spreadsheet Exercle Number 1 March 11 2020 Table 2. Cap Bull Spreadsheet Exerche Number YEAR BUT LORESTACION LETI USTA 300 10 GAL 30 Anne COM $25,000 Salvarea 000 Salvar Vaholainen of Working 300 SI 50 SU 50 20 ESOTO 30 30 Tema STOLCI SkrovaloEGLEPEL SC NetFlowNCE Pe Valo NCE Total Na Pre Valid SUS SO calculations. Table 1. Cap Bud Spreadsheet Exercise Number 1 March 11 2020 Wiscount kan Tax Rates YEAR Benningens investment Flow gummi Workin Capital oral Lorrainash Flows Can R Variable costs Table 2. Cap Bud Spreadsheet Exercise Number 1 Borini Aptions Discount Rate G00W Tax Rates Project Years Dominicananvestment Flors Buildings SO Equipment 3950 Work Capital $30,000 Operatinumptions: Annual Cash Revenu 25,000 Anna Variable Cash Costs S40,000 Annual Fixed Cash COM $25,000 Endin Value Assumption Salvar. Yalno Building 570,000 Salvare Value of equipment 35,000 Return of Workin. 390,000 Operating Cash Flow Buildin SL Dep. 20. ym.) EGSPLAYS Taxes C Flow altera 50 SC SO 50 50 SO $0 SU SO SO SC SO -50 $0 SO SO 50 -50 SC 30 SC 50 au H HIS Sc Value o Guipment DAwarda Total Net Cash Flow (NCF Print Value of NCF Total Ne Preset Valur SC SC SO 50 30 SO SO 50 SU SC SC

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!