Homework Help is Here – Start Your Trial Now!
Business
Accounting
Hello, which table would I use to find the ratio of exchange in a stock? I'm attaching the tables, but I'm not sure which table to use. Also, what would be the formula to use when doing that on an excel template?

Hello, which table would I use to find the ratio of exchange in a stock? I'm attaching the tables, but I'm not sure which table to use. Also, what would be the formula to use when doing that on an excel template?

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
100%

Hello, which table would I use to find the ratio of exchange in a stock? I'm attaching the tables, but I'm not sure which table to use. Also, what would be the formula to use when doing that on an excel template?

O Sign Ir x FINAN SPC Acade O FIN44 X Q Log in X Q Learni X * Log In x * Log In X SPC Financ X Mathv X SPC S X Signi AOL- a Solvec X + -> O File C:/Users/Starleana91/Downloads/FIN4414%20Case%202%20instructions%20NCC-Portable.pdf I Apps HCc HawkNet - Hillsbor. y! Yahoo - login YouTube f Facebook - Log In o.. O Domino's Home Pa... FOX Full Episodes | Empi. Target : Expect Mor. Ink Cartridges - Pri. HWet Seal | Clothing,. E Reading list FIN4414 Case 2 instructions NCC-Portable 2 / 3 | - 200% Table 3: Portable Coffee Express Balance Sheet (December 31, 2018) Assets Liabilities & Equity $ 3,000,000 2,000,000 7,000,000 7,250,000 14,750,000 $ 34,000,000 $ 3,600,000 5,900,000 14,800,000 9,700,000 $ 34,000,000 Cash Current liabilities Accounts Receivable Mortgages payable Inventory Common stock 1 Retained Earnings Total Liabilities & Equity Land Fixed assets (net) Total Assets Table 4: NCC and Portable additional data (December 31, 2018) Item NCC Portable Earnings available for $29,000,000 $12,580,000 common stock Number of shares of 7,000,000 3,400,000 Common stock 3 $ 43.30 $ 19* Market price per share (*Estimated by NCC) 8:46 AM O Type here to search 4) G 4/28/2021
Transcribed Image Text:O Sign Ir x FINAN SPC Acade O FIN44 X Q Log in X Q Learni X * Log In x * Log In X SPC Financ X Mathv X SPC S X Signi AOL- a Solvec X + -> O File C:/Users/Starleana91/Downloads/FIN4414%20Case%202%20instructions%20NCC-Portable.pdf I Apps HCc HawkNet - Hillsbor. y! Yahoo - login YouTube f Facebook - Log In o.. O Domino's Home Pa... FOX Full Episodes | Empi. Target : Expect Mor. Ink Cartridges - Pri. HWet Seal | Clothing,. E Reading list FIN4414 Case 2 instructions NCC-Portable 2 / 3 | - 200% Table 3: Portable Coffee Express Balance Sheet (December 31, 2018) Assets Liabilities & Equity $ 3,000,000 2,000,000 7,000,000 7,250,000 14,750,000 $ 34,000,000 $ 3,600,000 5,900,000 14,800,000 9,700,000 $ 34,000,000 Cash Current liabilities Accounts Receivable Mortgages payable Inventory Common stock 1 Retained Earnings Total Liabilities & Equity Land Fixed assets (net) Total Assets Table 4: NCC and Portable additional data (December 31, 2018) Item NCC Portable Earnings available for $29,000,000 $12,580,000 common stock Number of shares of 7,000,000 3,400,000 Common stock 3 $ 43.30 $ 19* Market price per share (*Estimated by NCC) 8:46 AM O Type here to search 4) G 4/28/2021
O SignI FINAN SPC Acade O FIN44 X Q Log in X Q Learni X * Log In x * Log In x SPC Financ X Mathv X SPC S X Signi AOL- a Solvec X -> O File C:/Users/Starleana91/Downloads/FIN4414%20Case%202%20instructions%20NCC-Portable.pdf I Apps HCc HawkNet - Hillsbor. y! Yahoo - login YouTube f Facebook - Log In o.. O Domino's Home Pa... FOX Full Episodes | Empi. Target : Expect Mor. 5 Ink Cartridges - Pri. HWet Seal | Clothing,. E Reading list FIN4414 Case 2 instructions NCC-Portable 1 / 3 200% To determine the viability of an acquisition of Portable Coffee Express by New Century Coffee Company, Ms. Chapman has provided recent financials for her company to NCC CFO Marisa Garcia. Mrs. Garcia has run cash flow forecasts for the consolidated company and estimated incremental cash inflows after taxes from the acquisition over the next 30 years (the relevant time horizon for the analysis). The pertinent financial data is included in the tables below. 1 Table 1: Estimated Incremental Cash Flows over Table 2: Portable Coffee Express Earnings 30 years for combined company $ 19,400,000 $ 19,100,000 $ 20,100,000 $ 22,550,000 $ 27,100,000 $ 28,200,000 (per yr.) Year 1 Year EPS Year EPS $ 1.85 $ 2.00 $ 2.20 $ 2.65 $ 2.95 $ 3.25 $ 3.45 $ 3.70 Year 2 2011 2015 Year 3 2012 2016 Year 4 2013 2017 Year 5 2014 2018 Year 6 - 30 3 8:45 AM O Type here to search 4) G 4/28/2021
Transcribed Image Text:O SignI FINAN SPC Acade O FIN44 X Q Log in X Q Learni X * Log In x * Log In x SPC Financ X Mathv X SPC S X Signi AOL- a Solvec X -> O File C:/Users/Starleana91/Downloads/FIN4414%20Case%202%20instructions%20NCC-Portable.pdf I Apps HCc HawkNet - Hillsbor. y! Yahoo - login YouTube f Facebook - Log In o.. O Domino's Home Pa... FOX Full Episodes | Empi. Target : Expect Mor. 5 Ink Cartridges - Pri. HWet Seal | Clothing,. E Reading list FIN4414 Case 2 instructions NCC-Portable 1 / 3 200% To determine the viability of an acquisition of Portable Coffee Express by New Century Coffee Company, Ms. Chapman has provided recent financials for her company to NCC CFO Marisa Garcia. Mrs. Garcia has run cash flow forecasts for the consolidated company and estimated incremental cash inflows after taxes from the acquisition over the next 30 years (the relevant time horizon for the analysis). The pertinent financial data is included in the tables below. 1 Table 1: Estimated Incremental Cash Flows over Table 2: Portable Coffee Express Earnings 30 years for combined company $ 19,400,000 $ 19,100,000 $ 20,100,000 $ 22,550,000 $ 27,100,000 $ 28,200,000 (per yr.) Year 1 Year EPS Year EPS $ 1.85 $ 2.00 $ 2.20 $ 2.65 $ 2.95 $ 3.25 $ 3.45 $ 3.70 Year 2 2011 2015 Year 3 2012 2016 Year 4 2013 2017 Year 5 2014 2018 Year 6 - 30 3 8:45 AM O Type here to search 4) G 4/28/2021
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Market Efficiency
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS