Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2017. In the tab named ‘Journal Entries’, show in journal entry form, the entries that would be made in preparation of the statement of cash flows.


OPTION #1

Complete the following questions. In addition to answering the items below, you must submit an analysis of the assignment. Analyze the specific outcomes and write an analysis directed toward the management team at Smart Company describing what the numbers mean and how they relate to the business. Submit journal entries in an Excel file and written segments in an MS Word document. For written answers, please make sure your responses are well-written, formatted per CSU-Global Guide to Writing and APA and have proper citations, where applicable.

Smart Company is preparing its financial statements for the year ended June 30, 2017. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017.

Download the excel spreadsheet found in the link below.

Required:

  1. Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2017.
  2. In the tab named ‘Journal Entries’, show in journal entry form, the entries that would be made in preparation of the statement of cash flows.
  3. Prepare Smart Company’s statement of cash flows for the year ended June 30, 2017. Prepare the statement of cash flows using the indirect method. Note: For full credit, you must prepare the statement of cash flow in good form with all necessary disclosures, including disclosures about noncash financing and investing activities.

Submit a well-formatted electronic file,

Assignment Choice #1: Consolidated Financial Statements Scenario

Assignment Choice #1: Consolidated Financial Statements Scenario

The first part is a scenario covering the topic of consolidated financial statements. The second part is the preparation of a consolidated financial statement. You will submit both parts separately.

Part 1: Scenario – Written

A new employee has been given responsibility for preparing the consolidated financial statements of Sample Company. After attempting to work alone for some time, the employee seeks assistance in gaining a better overall understanding of the way in which the consolidation process works. You have been asked to provide assistance in explaining the consolidation process. The employee is asking you to respond to the following questions. Please provide full explanations and use examples to support your work.

  1. Why must the eliminating entries be entered in the consolidation worksheet each time consolidated statements are prepared?
  2. How is the beginning-of-period noncontrolling interest balance determined?
  3. How is the end-of-period noncontrolling interest balance determined? Provide an example.
  4. Which of the subsidiary’s account balances must always be eliminated? Why?
  5. Which of the parent company’s account balances must always be eliminated? Why?

Your responses should be complete, cite appropriate examples, well written, and in conformity with the CSU-Global Guide to Writing and APA Requirements.

Part 2: Problem Solving – Journal

Using the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for the acquisition of Little, Inc. by Big, Inc. Within the worksheet, you are to:

  1. Select an accounting method (either cost or equity) and explain why you selected this method
  2. Perform the required journal entries
  3. Complete the consolidation worksheet
  4. Prepare the consolidated balance sheet in good form

Complete all work on the spreadsheet attached to this assignment; it will be your only deliverable

  • attachment

    20181102033937act470_studenttemplate_portfolio_opt1.xlsx

This paper is an exercise in critical thinking about prevention. Write a 500- to 750-word reaction paper on the social norms approach to alcohol and other substance use prevention with adolescents

Please note that this paper is to be on the social norms approach. There is one of your readings specifically focusing on this idea, at least. In order to do well, you must incorporate the idea regarding the social norms approach.

This paper is an exercise in critical thinking about prevention. Write a 500- to 750-word reaction paper on the social norms approach to alcohol and other substance use prevention with adolescents.

In your paper, be sure to address the following:

  1. Describe the effect of substance use in an adolescent’s social norms.
  2. What are the three specific paths for substance use prevention?
  3. Describe prevention strategies for adolescent substance use.
  4. All three points must be addressed.

Be sure to use at least two scholarly resources to support your reaction. You may use the assigned readings as resources for your paper or you may use other resources if you like.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.

NOTE: REMEMBER TO HAVE AN INTRODUCTION AND A CONCLUSION

Watch two clips from TV shows that exemplify Goffman’s theory of impression management.

Watch two clips from TV shows that exemplify Goffman’s theory of impression management. In this reflection paper

  • First summarize the two clips.
  • Then, apply(2) of Goffman’s concepts to each clip. Utilize the concepts of front stage/back stage, saving face, corrective and avoidance process, and impression management.

Chandler’s Job Interview

Impractical Jokers-Running the Gauntlet

Use APA format, 4 pages. not including cover page and reference page.

Use the publicly-traded company you chose in Module 1 (Ulta Beauty) and imagine it has made a strategic decision to start doing business in China.

Use the publicly-traded company you chose in Module 1 (Ulta Beauty) and imagine it has made a strategic decision to start doing business in China. Using the discussion, Currency Exchange Rates: A Case in China with Country Risk, (Chapter 7, Global Finance, page 192 of your textbook) as a model for the report you will write, prepare a report in which you:

  1. Develop a brief country risk assessment.
  2. Determine the political, economic, social, and capital risks associated with doing business in China. What are the most important factors to consider? Why?
  3. After years of keeping the Yuan pegged to the US dollar, in 2015 the Chinese allowed it to float freely in international currency exchange rate markets. You may read more about the Yuan reforms here. Many economists believe that keeping the Yuan pegged to the US dollar has caused it to be undervalued by 30 to 50 percent. Discuss what impact a revaluation of the Yuan might have on US multinationals doing business there, on China’s exports, and on Chinese citizens’ standard of living. What impact would a revaluation have on Chinese inflation and on purchasing power parity? Explain.

    Your paper should be about 2,000 words.

Hello, thank you for your assistance on this. No, not that I can think of. But the assignment research must be on Ulta Beauty. Thanks again and please let me know if there’s any info you need from me. (: Oh, and just a heads up, I’ve done this once before and still am pretty new at the whole process. This assignment is due next Monday, but I will peirodically check the site to see about the progress, talk with you soon!!

focusing on this idea, at least. In order to do well, you must incorporate the idea regarding the social norms approach. This paper is an exercise in critical thinking about prevention. Write a 500- to 750-word reaction paper on the social norms approach to alcohol and other substance use prevention with adolescents. In your paper, be sure to address the following: Describe the effect of substance use in an adolescent’s social norms. What are the three specific paths for substance use prevention? Describe prevention strategies for adolescent substance use. All three points must be addressed. Be sure to use at least two scholarly resources to support your reaction. You may use the assigned readings as resources for your paper or you may use other resources if you like. Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. NOTE: REMEMBER TO HAVE AN INTRODUCTION AND A CONCLUSION

focusing on this idea, at least. In order to do well, you must incorporate the idea regarding the social norms approach.

This paper is an exercise in critical thinking about prevention. Write a 500- to 750-word reaction paper on the social norms approach to alcohol and other substance use prevention with adolescents.

In your paper, be sure to address the following:

Describe the effect of substance use in an adolescent’s social norms.
What are the three specific paths for substance use prevention?
Describe prevention strategies for adolescent substance use.
All three points must be addressed.
Be sure to use at least two scholarly resources to support your reaction. You may use the assigned readings as resources for your paper or you may use other resources if you like.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.

NOTE: REMEMBER TO HAVE AN INTRODUCTION AND A CONCLUSION

The purpose of this assignment is for students to demonstrate mastery of operations management concepts and tools.

Purpose of Assignment

The purpose of this assignment is for students to demonstrate mastery of operations management concepts and tools.

Assignment Steps

Develop a 700- to 1,050-word memo to a prospective employer outlining your credentials, including: taking this class, all of the projects you have done for this class individually and with your team, and their impact on the businesses you have engaged with so a senior manager reading it would want to hire you as either an operations consultant or permanent employee.

Summarize the business case for each project.

Outline what you specifically accomplished, assuming these projects were implemented, and their estimated impacts on the business.

Utilize the learnings from Week 6 to highlight your skills in global sourcing, procurement, and outsourcing which can also be of benefit to your target firm.

Format your assignment as if you would be giving a presentation to senior management.

Assignment that were performed previously in class:

Flowchart Improvement Process

Statistical Process Control Methods

Six Sigma Yellow Belt Training

Lean Techniques

Operations Consulting

Operations Forecasting

use this reference: Jacobs, F.R. & Chase, R.B. (2014). Operations and supply chain management (14th ed). New York, NY: McGraw-Hill

How can association policies or employer policies be used to supplement legal requirements if an organization would like to protect its employees or clients from discrimination? Defend your answer(s).

Diversity of the healthcare workforce is a current trend as detailed in Module 1: Week 1. The Equal Employment Opportunity Commission (EEOC) enforces Title VII of the Civil Rights Act of 1964 (Title VII), the Age Discrimination in Employment Act (ADEA), the Americans with Disabilities Act (ADA), the Equal Pay Act of 1963 (EPA), and the Rehabilitation Act of 1973. Select 1 law you believe is important to employees and provide a brief description of that law and its impact on employees. How can association policies or employer policies be used to supplement legal requirements if an organization would like to protect its employees or clients from discrimination? Defend your answer(s).

MUST BE 600 WORDS

MUST CITE 4 SCHOLARLY SOURCES INCLUDING JOURNALS

MUST INCLUDE 2 BIBLE VERSES INSIDE THE PAPER

CITE SOURCES WITH APA FORMAT

MUST SUBMIT TOMORROW

ondé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All ships are rated on a 100-point scale,

ondé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All ships are rated on a 100-point scale, with higher values indicating better service. A sample of ships that carry fewer than 500 passengers and a sample of ships that carry 500 or more passengers is provided in the Microsoft Excel Online file below (Condé Nast Traveler, February 2008).

Round your all answers to two decimal places.

Open spreadsheet

a. What is the point estimate of the difference between the population mean rating for ships that carry fewer than 500 passengers and the population mean rating for ships that carry 500 or more passengers?

fill in the blank 2

b. At 95% confidence, what is the margin of error?

fill in the blank 3

c. What is a 95% confidence interval estimate of the difference between the population mean ratings for the two sizes of ships?

fill in the blank 4 to fill in the blank 5

Graphical user interface, application, table Description automatically generated

Graphical user interface, text, application, email Description automatically generated

Graphical user interface, application Description automatically generated

Graphical user interface, text, application, email Description automatically generated

Graphical user interface, application, table, Excel Description automatically generated

FIN 340 Final Project Scenarios and Tables

FIN 340 Final Project Scenarios and Tables

You will use these scenarios and tables to complete the final project.

 

Client 1:

 

Ezra, age 26, is single. However, he is dating and preparing to get engaged. He will need roughly $5,000 for an engagement ring almost immediately, and expects he will need $10,000–$15,000 for the wedding in the next 12–24 months. He is currently employed and earns about $70,000 a year in salary. This salary is enough to cover all his taxes and normal living expenses of approximately $4,800. This leaves him with about $1,000 in savings each month ($350 to 401K, $650 to savings). He has been able to save roughly $15,000 to date in a 401K plan from work and about $20,000 in cash savings. His 401K plan has been invested 100% in the stock market, including some sector-specific funds. His other savings have been in interest-bearing savings and cash substitutes such as money market funds. He recently received a windfall of $60,000, and this prompted him to come to you for some advice. The following are few of Ezra’s comments to help guide your thoughts:

 

“I understand I am young, so I need to take on as much risk as I can.”

“I am willing to lose 30–40% on my invested capital if the return is commensurate.”

“I do like to have a decent sized cushion in the bank in case something happens at my job.”

“I don’t foresee my risk tolerance changing after I get married.”

“Do you have any good stock tips?”

 

Client 2:

 

Jacob and Rachel, 53 and 52 respectively, are married with four children. Two of the children are currently in college, and two are in high school. They expect the other two children to attend college. The couple has done relatively well for themselves and earn roughly $275,000 before tax between the two of them, which equates to $190,000 after taxes. They live well below their means, and this should allow them to cover all of their children’s college expenses out of pocket, but it will not leave much for them to save over the next six to eight years. Through savings and portfolio growth, they have managed to accumulate $900,000. To this point, they have been moderately aggressive (70–75% equities) with their portfolio, but they feel that they need to begin preparing the portfolio for partial retirement in eight years, and full retirement in 13 years.

 

1. “I know we still need to be somewhat aggressive—we could live until we’re 90—so we need to plan for some growth even in retirement.”

“We definitely can’t afford to take a big hit in our portfolio. We don’t have enough time to recover.”

“Our jobs allow us to work part-time in retirement, and we will probably do so as long as we are able.”

“What do bond yields look like today?”

“I think we’ll need to draw on 3–5% of our portfolio in retirement. We’d like to earn enough income from the portfolio to cover that.”

CAPM Inputs:

 

Market Return 9%

Risk-free Rate 0.75%

 

Stock Analysis Table:

 

Symbol Estimated Beta Dividends Earnings Sales Free Cash Flow 5-Year Dividend Growth Average Industry P/E Ratio Average Industry P/S Ratio Free Cash Flow Growth
IBM 0.86 Use Last Year Use Last Year Use Last Year Use Last Year 13.7 23.7 1.12 2.60%
KO 0.66 Use Last Year Use Last Year Use Last Year Use Last Year 8.3 22.6 2.2 6.50%
BMY 0.78 Use Last Year Use Last Year Use Last Year Use Last Year 2.9 24.4 3.37 N/A
ORCL 1.1 Use Last Year Use Last Year Use Last Year Use Last Year 21.1 20.5 4.45 10%
MMM 0.98 Use Last Year Use Last Year Use Last Year Use Last Year 15.1 23.8 2.59 7%
BAX 0.75 Use Last Year Use Last Year Use Last Year Use Last Year -16.9 36.09 3.68 N/A
BIG 1.04 None Use Last Year Use Last Year Use Last Year N/A 23 1.12 N/A
NFLX 1.57 None Use Last Year Use Last Year Use Last Year N/A 52.5 6 N/A
AKAM 1.34 None Use Last Year Use Last Year Use Last Year N/A 41.8 3.58 17%
GE 1.12 Use Last Year Use Last Year Use Last Year Use Last Year 9.7 23.8 2.59 N/A

 

 

Available Assets Table: Stocks listed in Analysis Table and these additional assets

 

Symbol Estimated Beta Standard Deviation
SPY 1 13%
IWM 1.15 16.50%
EFA 1.03 15%
EEM 1.09 20%
SHY 0 1%
IEF -0.2 6%
TLT -0.48 13%
LQD -0.02 5.25%
HYG 0.38 7.50%

 

 

Ex-post Return Statistics:

 

Symbol

Holding Period Return Standard Deviation   Benchmarks Holding PeriodReturn Standard Deviation
IBM 8% 20.00%   Growth 9.6% 13.1%
KO 6% 13.00%   Capital Appreciation 8.1% 8.6%
BMY 13% 28.00%   Income 7.7% 7.2%
ORCL 2% 16.00%   Capital Preservation 5.8% 5.2%
MMM 6% 14.00%        
BAX -6% 16.00%        
BIG 13% 32.00%        
NFLX 18% 45.00%        
AKAM 21% 37.00%        
GE 10% 16.00%        
SPY 9% 11.00%        
IWM 14% 18.00%        
EFA 9% 15.00%        
EEM -1% 19.00%        
SHY 1% 1.00%        
IEF 4% 6.00%        
TLT 4% 13.50%        
LQD 7% 6.00%        
HYG 8% 8.00%        

 

 

 

 

 

 

 

FIN 340 Final Project Scenarios and Tables

 

You will use these scenarios and tables to complete the final project.

 

 

Client 1:

 

 

Ezra, age 26, is single. However, he is dating and preparing to get engaged. He will need roughly $5,000 for an engagement ri

ng

almost immediately, and expects

he will need $10,000

$15,000 for the wedding in the next 12

24 months. He is currently employed and earns about $70,000 a year in salary. This salary is

enough to cover all his taxes and normal living expenses of approximate

ly $4,800. This leaves him with about $1,000 in savings each month ($350 to 401K, $650

to savings). He has been able to save roughly $15,000 to date in a 401K plan from work and about $20,000 in cash savings. His

 

401K plan has been invested 100%

in the sto

ck market, including some sector

specific funds. His other savings have been in interest

bearing savings and cash substitutes such as money market

funds. He recently received a windfall of $60,000, and this prompted him to come to you for some advice. The

following are few of Ezra’s comments to help

guide your thoughts:

 

 

1.

 

“I understand I am young, so I

need

 

to take on as much risk as I can.”

 

2.

 

“I am willing to lose 30

40% on my invested capital if the return is commensurate.”

 

3.

 

“I do like to have a decent sized

cushion in the bank in case something happens at my job.”

 

4.

 

“I don’t foresee my risk tolerance changing after I get married.”

 

5.

 

 

“Do you have any good stock tips?”

 

 

Client 2:

 

 

Jacob and Rachel, 53 and 52 respectively, are married with four children. Two of th

e children are currently in college, and two are in high school. They expect the

other two children to attend college. The couple has done relatively well for themselves and earn roughly $275,000 before tax

 

between the two of them, which

equates to $190,00

0 after taxes. They live well below their means, and this should allow them to cover all of their children’s college expenses

 

out of pocket, but

it will not leave much for them to save over the next six to eight years. Through savings and portfolio growth,

 

they have managed to accumulate $900,000. To

this point, they have been moderately aggressive (70

75% equities) with their portfolio, but they feel that they need to begin preparing the portfolio for partial

retirement in eight years, and full retirement

in 13 years.

 

 

1.

 

“I know we still

need

 

to be somewhat aggressive

we could live until we’re 90

so we need to plan for some growth even in retirement.”

 

2.

 

“We definitely can’t afford to take a big hit in our portfolio. We don’t have enough time to recover.”

 

3.

 

“Our j

obs allow us to work part

time in retirement, and we will probably do so as long as we are able.”

 

4.

 

“What do bond yields look like today?”

 

5.

 

“I think we’ll need to draw on 3

5% of our portfolio in retirement. We’d like to earn enough income from the portfolio

 

to cover that.”

 

 

 

FIN 340 Final Project Scenarios and Tables

You will use these scenarios and tables to complete the final project.

 

Client 1:

 

Ezra, age 26, is single. However, he is dating and preparing to get engaged. He will need roughly $5,000 for an engagement ring almost immediately, and expects

he will need $10,000–$15,000 for the wedding in the next 12–24 months. He is currently employed and earns about $70,000 a year in salary. This salary is

enough to cover all his taxes and normal living expenses of approximately $4,800. This leaves him with about $1,000 in savings each month ($350 to 401K, $650

to savings). He has been able to save roughly $15,000 to date in a 401K plan from work and about $20,000 in cash savings. His 401K plan has been invested 100%

in the stock market, including some sector-specific funds. His other savings have been in interest-bearing savings and cash substitutes such as money market

funds. He recently received a windfall of $60,000, and this prompted him to come to you for some advice. The following are few of Ezra’s comments to help

guide your thoughts:

 

1. “I understand I am young, so I need to take on as much risk as I can.”

2. “I am willing to lose 30–40% on my invested capital if the return is commensurate.”

3. “I do like to have a decent sized cushion in the bank in case something happens at my job.”

4. “I don’t foresee my risk tolerance changing after I get married.”

5. “Do you have any good stock tips?”

 

Client 2:

 

Jacob and Rachel, 53 and 52 respectively, are married with four children. Two of the children are currently in college, and two are in high school. They expect the

other two children to attend college. The couple has done relatively well for themselves and earn roughly $275,000 before tax between the two of them, which

equates to $190,000 after taxes. They live well below their means, and this should allow them to cover all of their children’s college expenses out of pocket, but

it will not leave much for them to save over the next six to eight years. Through savings and portfolio growth, they have managed to accumulate $900,000. To

this point, they have been moderately aggressive (70–75% equities) with their portfolio, but they feel that they need to begin preparing the portfolio for partial

retirement in eight years, and full retirement in 13 years.

 

1. “I know we still need to be somewhat aggressive—we could live until we’re 90—so we need to plan for some growth even in retirement.”

2. “We definitely can’t afford to take a big hit in our portfolio. We don’t have enough time to recover.”

3. “Our jobs allow us to work part-time in retirement, and we will probably do so as long as we are able.”

4. “What do bond yields look like today?”

5. “I think we’ll need to draw on 3–5% of our portfolio in retirement. We’d like to earn enough income from the portfolio to cover that.”