Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show how you get the answer. Your company is undertaking a new project. A building was purchased 10 years ago for $750,000 depreciated straight

please show how you get the answer. image text in transcribed
Your company is undertaking a new project. A building was purchased 10 years ago for $750,000 depreciated straight line to $150,000 (the land value) over 30 years. It is now worth $500,000 (including $150,000 land). The project requires improvements to the building of $100,000. The improvements are depreciated straight line to zero over the life of the project. The project will generate revenues of $325,000 $350,000, $375,000 and $400,000 for years 1-4, respectively. Annual cash operating expenses are $80,000, $100,000, $120,000 and $140,000, respectively. The project will last 4 years, at which time the building will be sold for $600,000. Taxes are 40% and rate of return is 10%. Using Excel, prepare a spreadsheet and upload: 1. What is the total depreciation per year? II. Show projected annual income statements. III. What is the initial cost (CFO)? IV. What are annual operating Cash Flows? V. What is the ending Cash Flow from the sales of the assets? VI. What is the total annual Cash Flows? VII. What is NPV? Show work VIII. What is Profitability Index? Show work. (at least 2 decimals) IX. What is payback in whole years? X. What is Average Accounting Return? (correct format with at least 2 decimals) XI. Show how (algebraic format), IRR would be solved (do not solve)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Auditing And Assurance Services

Authors: Alvin A. Arens . Randal J. Elder . Mark S. Beasley

18th Global Edition

1292448989, 978-1292448985

More Books

Students also viewed these Accounting questions

Question

11. Identify the apotheosis in Indiana Jones and the Last Crusade.

Answered: 1 week ago

Question

1. Describe the types of power that effective leaders employ

Answered: 1 week ago