Create an Excel spreadsheet and upload it to Canvas under the Assignment. Do all of your work in a...

Question

Create an Excel spreadsheet and upload it to Canvas under the Assignment. Do all of your work in a single Excel tab. You should format the spreadsheet so that it will print on no more than two sheets of paper. The spreadsheet should be formatted to be attractive and professional. The printed and electronic versions of the spreadsheet should be a something that you would be proud to submit to your manager or supervisor at your professional workplace.

Hint: Use Print Preview to see what the spreadsheet will look like when it is printed. You may need to change the spreadsheet to Landscape Orientation.

Except for the source information, you should not type any other numbers into the spreadsheet. You should use formulas and references to create a working model. All calculations should be done in the spreadsheet. You may not calculate or display any value more than once, or enter any source data more than once. You must also record all assumptions.

Even though this is an assignment that is done outside of class, the rules regarding cheating still apply. You ARE allowed to work with your classmates on the ideas and processes involved, but you must create and submit your own unique work. Submitting the work of others will be a violation of the UT honor code.

model-2-capital-budgeting-model-instruction-yonxxozi.docx

Shakeel · Accepted Answer

Sheet1
		Cost of water bottling line	$1,870,000				Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
		Refurbishment cost	$1,250,000		1	Initial investment	-$3,120,000
		Total investment	$3,120,000			Add: working capital	-$96,000.00
		Life of botttlting line (years)	6			Sales / Revenue		$1,630,000.00	$1,703,350.00	$1,780,000.75	$1,860,100.78	$1,943,805.32	$2,031,276.56
		Book value	0			Less: Cost		$680,000.00	$710,600.00	$742,577.00	$775,992.97	$810,912.65	$847,403.72
		Depreciation per year	$311,666.67			Less: Depreciation		$311,666.67	$311,666.67	$311,666.67	$311,666.

Create an Excel spreadsheet and upload it to Canvas under the Assignment. Do all of your work in a single Excel tab. You should format the spreadsheet so that it will print on no more than two sheets...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment