Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started