Question: GIVE EXCEL WORK PLEASE. PLEASE DO WORK IN EXCEL AND SHOW. An ongoing business should be able to produce cash flows as listed below. It's

GIVE EXCEL WORK PLEASE.

PLEASE DO WORK IN EXCEL AND SHOW.

An ongoing business should be able to produce cash flows as listed below. It's offered for sale at a price of $1.5 million, and most interested buyers understand the current owner will unlikely accept anything less. If an appropriate opportunity cost of money is 9.0%, what is the value of this business for anyone who buys today from the owner?

Year 1 $305,000

Year 2 $327,000

Year 3 $348,500

Year 4 $385,000

Year 5 $422,000

Do not round the intermediate calculations. Enter your answer, however, as a dollar number rounded to the nearest whole dollar. No decimals, in other words. Do not enter dollar signs or commas.

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!

Hello, I need help with the questions from the paper: Bleak weather for sun-shine AG: A case study of impairment of assets! ISSUES IN ACCOUNTING EDUCATION Vol. 30, No. 2 2015 pp. 113-126 American...

GPS-to-Go: Case Study GPS-to-GO Case You are Joseph Thomas, Vice-President of Operations for GPS-to-GO and responsible for preparing the factory to build, test and ship GO I, II, and II GPS products....

EXCEL PROJECT: PART I INSTRUCTIONS Company Information (Tab 1), and Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4) Companies listed is Kohls Go to the Securities and Exchange...

Please, help asap! I have one day. Feedback will be given. & show some work. [in Excel] For the final project you will need you to create a spreadsheet /proforma of the cash flows from a property....

Roger and Wanda Person are average folks who want to live ?the good life.? They meet at CMC during college and later decide to get married, raise a family, buy a house, and save for their son?s...

plz help!!! The financial information for the past two years (2018 and 2017) is provided. Using a spreadsheet application, such as Microsoft Excel, and the information from the previous years,...

Would you be able to put together another monthly cash flow analysis, this time for year 1? INCOME STATEMENT Year 1 269,115.00 48,930.00 20,388.00 338,433.00 $ $ $ $ COGS $ 113,940.00 $ 125,940.00 $...

Below is the assignment, attached in the excel file is actually all the answers, I need these transferred into my own excel file, answering all the questions below. Integrated mini-case: ?Working...

FILE TOOLS VIEW 6401819_1_writing-case--4 - Word (Product Activation Failed) Financing Early Operations Musk's first entrepreneurial venture was to join up with his brother, Kimbal, and establish...

Blood pressure in Argentinosaurus. (a) If this long-necked, gigantic sauropod had a head height of 21 m and a heart height of 9.0 m, what (hydrostatic) gauge pressure in its blood was required at the...

Weller Corporation Comparative Balance Sheet (dollars in thousands) Assets Current assets: Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Property and equipment: Land...

Jorge is irvesting in a 4 0 1 ( k ) that promises 4 . 9 9 % annual growth. He plans on investing $ 2 0 0 each month for 3 5 vears ( there is no emplover matchingl. Excel calculates an overall account...

gEnabled US 341 iness Prance James Henry, bought 1000 bonds of ABC Company's 20 year, tocoupon bands when the bond was issued 5 years ago. The yield to maturity on the bonds when it was issued was...