Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen

16th edition

978-1259277160

Students also viewed these Finance questions