Category: Accounting

Accounting 102 Project on Capital Budgeting (Writing Assignment)
Madison Capital Group is considering allocating a limited amount of capital investment funds among four proposals.  The amount of proposed investment, estimated income from operations, and net cash flow for each proposal are as follows:
please look at the files I attached.

You work for a global manufacturing company that sources raw materials from international suppliers and sells its products in multiple countries. The company recently experienced a substantial exchange rate fluctuation that affected its financial results.
The company entered into a significant foreign currency transaction to purchase raw materials. However, by the time the payment was due, the exchange rate had moved significantly against the company, resulting in unexpected costs.
Based on this scenario, discuss the following in your initial post:
How should the company account for this unfavorable exchange rate movement in its financial statements?
What are the potential implications on the income statement, balance sheet, and cash flow statement?
Discuss possible hedging strategies the company could have employed to mitigate the foreign exchange risk associated with this transaction.
Which hedging instruments or techniques would you recommend and why?
How would these strategies have affected the financial results in this scenario?

Comparative Analysis of Working Capital Management Practices and Firm Performance Across Industries in Australia Amid COVID-19. Reference style: APA. Write Master’s Thesis Proposal based in the field of Accounting. Include in the proposal: title, problem statement, background of the study, research contribution, research motivation, research significance, Aim, research question, objectives and hypotheses, Timeline, Budget, Literature review, methodology, theory, Implication. Note: include A grade journal references plus recent references. Write approximately 1500 words.

I have a project and need help with the Excel part. Please create a vertical bar pivot chart to visualize the profit by year. Include a descriptive chart title and labeled vertical axes.
The data is all in the excel. 
this is the full instructions for the assignment:
Using the data, calculate an estimate of gross profit on each movie 
Rank the movies from highest to lowest profitability. 
Create a pivot table to summarize and rank the profit by year. 
Create a vertical bar pivot chart to visualize the profit by year. Include a descriptive chart title and labeled vertical axes.
Is there an effect based on year of release? Explain. What may be the cause for this effect? 
Please see if everything else is right & help answer the last question (Is there an effect based on year of release? Explain. What may be the cause for this effect? )

Overview
The FASB Accounting Standards Codification (ASC) refers to the set of
authoritative generally accepted accounting principles (GAAP) that the
FASB recognizes. The core purpose of the codification is to establish a
user-friendly way to follow best practices when applying GAAP for
accounting professionals and companies. FASB Codification recommends
that GAAP be applied to nongovernmental entities.
Directions
Use the Master Glossary and FASB Accounting Standards Codification
found in your module resources. The complete FASB Codification will need
to be cited. An example of a complete FASB Codification reference is:
820-10-30-02. Be sure to include citations for any answers you need to
explain or define.
Master Glossary
Define ordinary income (loss).
Define error in previously issued financial statements.
Define earnings per share.
List the three characteristics included in the definition of a publicly traded company.
FASB Codification Research
Cite the complete FASB Codification reference used for the characteristics of related parties.
Describe at least four examples of related parties.
Cite the complete FASB Codification reference used for the explanation of segment reporting.
Explain when segment reporting quantitative thresholds requires a public company to report separate information about an operating segment.
Cite the complete FASB Codification reference used for the explanation of interim reporting relating to SEC-registered companies.
Explain whether it is acceptable for an SEC-registered company to state the impracticality
of determining components of inventory using the gross profit method in
their interim reporting. Consider the following questions to guide your
response:
Is it acceptable?
Would a public company count inventories during each interim period?
Will management be able to make reasonable estimates of inventory estimates? Why or why not?

I attached pictures of what needs to be done. I also attached a picture of example 2 which is needed for problem 25&26.

Overview
The statement of cash flows is one of the primary financial
statements that a company must prepare each year and involves the
company’s operating, investing, or financing activities. The statement
of cash flows can be analyzed and leveraged in making decisions
pertaining to lending and investing.
Directions
This assignment will use the statement of cash flows of The Coca-Cola
Company and PepsiCo, Inc. presented in Appendices C and D,
respectively, which are linked in the Supporting Materials Section. The
companies’ complete annual reports, including the notes to the financial
statements, are also available online and linked in the Supporting
Material section. You will use each company’s statement of cash flows to
perform calculations and explain your rationale behind these
calculations. Remember, you will need to look at both sets of financials
for each company and address the rubric criteria for both companies.
Specifically, you must address the following rubric criteria:
Operating Activities
Identify the method of computing net cash provided by operating activities for each company.
Calculate the amounts of cash provided by operating activities reported each company in 2020.
Explain the two companies’ trends in net cash provided by operating activities over the period 2018 to 2020 for each company.
Investing Activities
Identify the most significant item in the investing activities section reported by each company in 2020.
Financing Activities
Identify the most significant item in the financing activities section reported by each company in 2020.
Depreciation and Amortization
Identify what activity would depreciation and amortization be reported on in each company’s statement of cash flow using the indirect method.
Explain why each company reported on depreciation and amortization where they did in their statement of cash flows.
Identify the amount of depreciation and amortization for each company.
Statement of Cash Flows and Ratios
Compute the current cash debt coverage for each company.
Compute the cash debt coverage for each company.
Explain what conclusions can be drawn from the
current cash debt coverage ratio and the cash debt coverage ratio for
each company. Address the following questions in your response:
What conclusions can be drawn from the current cash debt coverage ratio?
What conclusions can be drawn from the cash debt coverage ratio
WILL NEED SCHOOL LOGIN FOR INFO LINKS

If you do not already have Excel installed on your computer, please download it (for free) from the UMaine IT page here: https://umaine.edu/it/microsoft-office365/ . Please do NOT do the project in Numbers or Google Sheets. I cannot open them and will not grade them. Virtually no one in the business world uses either, so get used to it.
Download the FSA Spreadsheet from its folder in Brightspace (if you’re reading this, you’re already there) and open it.
Identify which two companies you will be comparing: Enter your first and last names in the boxes as indicated (D3 and K3). Use the first letter of your first and last names to select companies from columns R-AC (First name) and AE-in the appropriate cells (D5 and K5).
Copy the financial statements from 2020 for Company 1 and paste it in Column B. To do so, highlight the cells you want to copy (Rows 9 through 31 and Rows 35 to 48 – do these separately!) and use Ctrl-C. Then select cell B9 and use Ctrl-V to Paste. (You can also right-click and select copy and paste from the popup menu)
IMPORTANT NOTE: YOU SHOULD NOT TYPE ANY NUMBERS ANYWHERE IN THIS SPREADSHEET. ALL DATA CAN EITHER BE COPIED FROM ELSEWHERE WITHIN THE SHEET OR CALCULATED USING FORMULAS. UNDER NO CIRCUMSTANCES SHOULD YOU CALCULATE SOMETHING ON YOUR CALCULATOR AND THEN TYPE THE NUMBER INTO EXCEL. IF YOU DO SO I WILL TAKE POINTS OFF!
Repeat the process for 2019 for Company 1 and for 2020 and 2019 for Company 2 (pasting the numbers into columns D, I, and K).
Do you see a bunch of ####s? If so, that just means that the numbers are too big for the cell. You can click and drag the column borders up at the top of the worksheet to make them larger! Or you can doubleclick the column’s right border up top and it will auto-size the column for you.
Create Common Size Financial Statements for both companies and both years.
Divide all Balance Sheet accounts by Total Assets. 
Divide all Income Statement accounts by Total Revenue
See the following Excel Videos for help:
Mathematical formulas: divide, subtract (Chapter 2)
How to use Absolute Cell Referencing in Excel (Chapter 10)
This will allow you to copy and paste the formula from Cell C9 to the rest of the balance sheet accounts and Cell B35 to the rest of the income statement accounts
Note that you will need a new absolute reference for each year’s financial statements. Don’t divide 2020’s Cash by 2019’s Total Assets!
Highlight your common size calculations and click the % button within the “Number” section of the top menu ribbon (Under the Home tab). This will turn all those decimals into nice pretty %s.
Calculate % Change of All Balance Sheet and Income Statement accounts for both companies. 
To calculate the change in cash, enter =(B9 – D9)/D9 into cell G9.
Copy and paste that cell’s formula into Column G for the rest of the financial statement lines for Company 1
Repeat the process for Company 2 using a similar formula.
Use that little % button here too! No ugly decimals for us!
Perform Ratio Calculations with Excel formulas for Company 1 in Cells D50 to D63. Please note that I only want ratios for a single year.
Current Ratio: Total Current Assets / Total Current Liabilities
Working Capital: Total Current Assets – Total Current Liabilities
Accounts Receivable Turnover: Revenue / Average Accounts Receivable
Use the formula B35/(AVERAGE(B10, D10))
Make sure you have two )s at the end!
Assume that all revenues were Credit Sales. That’s how business typically works.
Average Collection Period: 365 / Accounts Receivable Turnover
Use the formula = 365/B52
For funsies, type a different number into B35 and see how both AR Turnover and Average Collection Period update!
Click the undo button to return Revenue to the correct number.
Inventory Turnover: Cost of Goods Sold / Average Inventory
Adapt the formula from c. above 
Don’t forget that this is COGS, not Sales!
Days inventory Held: 365 / Inventory Turnover
Adapt the formula from d above. 
Funsies again, if you wish, followed by undo.
Debt to Assets: Total Liabilities / Total Assets
Debt to Equity: Total Liabilities / Total Equity (note that this is different than Total Assets. If your number is the same as g above, you screwed up!)
Times Interest Earned: “Operating Income” / Interest Expense
Asset Turnover: Revenue / Average Total Assets
See c. above for how to do the average
Return on Assets: Net Income / Average Total Assets
See c. above for how to do the average
Return on Equity: Net Income / Average Total Equity (note that this is different than Total Assets)
See c. above for how to do the average
Let’s make these ratios pretty! 
For the two return ratios, use that % button again.
For all the others, click on the button that looks like 00->0 to the right of the % button. This will decrease the number of decimal places shown. We don’t need more than one, so turn that 2.353672346 into 2.4!
Verify that the numbers make sense. If a company has an AR turnover of 500, that means they are collecting 100% of their receivables more than once a day. This is, obviously, dumb. We have numbers from the examples in the text and the notes. If your calculation is a factor of 10 different from those, you’re probably wrong.
Copy the formulas from Column D to column K.
Highlight cells B50 toB63 and type Ctrl-C
Click in Cell I50
Type Ctrl-V
Look! Now you don’t have to type in all those formulas again! Or even redo the formatting! Yay Excel!
Analyze the data!
For each ratio, indicate which Company (1 or 2) has a better ratio in Column N.
Note that higher is not always better. Think about what each ratio means and whether you would like that number to be higher or lower. Review the notes or the text (or the internet) if necessary. This is part of the Big Payoff of making all MBS students take ACC 201.
Be consistent! Average Collection Period is just AR Turnover divided into 365. If company 1 is better for Turnover, it’s going to be better for Average Collection Period.
Do not enter anything in cells N57 or N58. Debt to Assets and Debt to Equity, being leverage ratios, are ambiguous without deeper analysis. That is, you can’t say that one company’s ratio is better or worse, just higher or lower.

It’s a group project about a chosen company and my groups chosen company is Bayerische Motoren Werke AG (BMW)
my role as a group member is to perform
Member 2: Data Collection & Analysis
Task: Handle the data collection and analysis portion.
Subtasks:
Gather financial reports of the chosen company and its competitors.
Perform cross-sectional and time-series analysis.
Focus on one aspect such as sales, cost, or fixed assets and provide a line-item breakdown.
Please read through and follow carefully these instructions as well as all the other documents that i have atahced because following is vital for me to do it correctly
Accounting 978 Spring 2024
The term project is a group project. Students should form groups of from three (3) to five (5) people and submit reports on Luiss Learn. Reports will be graded based on both their analysis (contents) and writing (presentation) from 0 to 10 points (no decimal) and count toward 20% of the course grade. All members of a group will receive the same grade for the project.
Each additional member beyond the cap (5) will result in two (2) points of penalty.
Eachmemberbelowtheminimumrequirement(3)willresultintwo(2)pointsofpenalty,
e.g., if you do the project solo, you will get at most 10 – (3 – 1) × 2 = 6 points. The group project aims to expose you to:
• teamwork,
• data collection,
• data analysis, and
• academic/business writing
Excellent report should show accomplishments in these aspects.
1 Requirements
Write a report about a listed company of your choice. The company of your choice should be a merchandiser or a manufacturer. There is no additional limitation such as where the company is listed, etc.
Your report should enhance the reader’s understanding of the company and help the reader to decide whether it is financially rewarding to invest in the company.
In so doing, your report must include cross-sectional (against competitors) and time series (against the company’s past) analysis. The number of competitors should be at least as many as the number of group members.1 Time series should be at least five (5) years and ending in 2023 the earliest.
Contents The analysis must be based on the company and its related companies’ financial reports. You do not need to cover all aspects of the company. Focus on just one aspect (sales, cost, fixed assets, etc.).
Your analysis must break down at least one line-item on either the income statement or the balance sheet (according to the aspect you are focusing on).
Line-itembreakdownisoftennotreadilyavailableonGoogle/Yahoo!Finance,etc.,which means you must consult the notes to the original financial reports.
You are allowed to use Google/Yahoo! Finance for other general-purpose analysis.
Not always possible, but performing a value-chain analysis (on suppliers and customers)
is a major plus.
1
Hint: Competitors can be identified from proxy statements.
1
Choice of subject Despite that there is almost no limitation on choice of subject (company you would cover), I strongly discourage crowding around a few star companies. I will rank reports covering the same subject, and no two reports on any subject will receive the same grade. Different aspects of the same company are considered as different subject.
• Suppose, in an extreme case, 11 groups decide to cover Apple’s sales, then the worst report will receive 0 point regardless of absolute report quality.
I encourage you to choose Italian and European subjects and test whether what you’ve learned in the course is applicable internationally. Smaller and more focused companies are often easier to analyze.
Submission You should submit either a Word or PDF file on Luiss Learn. Deadline is at 11:59PM on May 8, 2024, regardless of which final exam you are registered to. I will not grade before the deadline, so you may submit revisions. Regarding the document—
2
The electronic document should be formatted on A4-sized pages, with page margin of 2–3 centimeters on each side, font size between 11 and 12, and text double-spaced.
The text should not exceed 10 pages. There is no minimum page limit. Tables, figures, and list of reference do not add toward the page count.
The file should not exceed 10 megabytes.
Recommended practice
The title Although not always easy, entitling your report with a catching phrase can help you communicate your findings and make a good impression before your reader gets to the text. That said, a plain title such as “Group project on Company X” is still better than no title.
Put your names immediately under the title. Do not withhold your names until the end or even forget to put them into the document. Do not include your professor’s name.
When submitting your report electronically, include your (last) names as part of the file name.
Text formatting Choose a conventional typeface with serif. If you cannot decide, use Times New Roman.
Once format choices are made (typeface, font size, page margin, and line spacing), use then throughout the entire documents.
Use bold fonts or italic shapes sparsely if at all.
It’s okay to center titles, section titles, and captions. But do not center blocks of text (para- graphs, even entire sections).
Tables and figures Use tables and figures when they communicate better than text. All tables and figures should have captions and short explanatory notes and be numbered consecutively. Tables and figures should occupy the full width of the page. Do not use a table and a figure to show the same set of information. Instead of inserting tables and figures into the text, consider putting all tables and figures at the end of your report.
In tables:
Format numbers in a suitable and consistent way within the table and align them to the
right side of each cell.
A single number should not run over one row no matter what.
Do not use vertical rules at all and use horizontal rules sparsely.
Do not copy-paste tables as images.
In figures:
• Always specify what are on the x- and y-axes in the notes.
2
• Do not include random imagery in your report.
Screenshots The most common and offensive mistake is to bloat your report with screenshots. Do not use screenshots unless the screenshots per se are what you intend to show. (You don’t need to screenshot the financial reports to prove that you’ve consulted them.) Instead, extract and process the information from the source and re-tabulate the data properly; this is
part of the exercise.
Report structure Breaking your report into sections to highlight its structure helps you orga- nize your report in a logical way. You may find the following layout useful:
Introduction Provide basic information about the subject you chose (1 paragraph). This can
be extended if the subject is not a household name. Also explain why you are interested in the subject in the mode to convince your reader to share your view. Briefly summarize what you’ve done and what you’ve found.
Main body Describe your method and your finding in detail. Focus on what you do, (when necessary) justify your research choice, and most importantly, what you’ve found. You often need more than one sections here.
Conclusion The conclusion should be based on your work. No one can perform the most comprehensive analysis, so it is important you acknowledge the incompleteness of your report.
Reference An itemized list of sources you’ve consulted.
Reference Each item in the reference should contain at least the name of the author(s), the year in which the source is published, and the title of the source.
Sources can be journal articles, working papers, books, book chapters, news articles, maga- zine articles, web pages, etc.
You shall not list financial reports as your source. It suffices as long as you mention in the text that you used the financial reports. The same applies to websites, such as Google finance, SEC EDGAR, etc.
For online resource, you should provide the Uniform Resource Locator (URL). Check if URLs can be shortened and make sure they work after shortening.
Review your report Run your document through a grammar checker and review issues it raises. You don’t have to accept every change it suggests, but you need to have a reason not to accept a proposed change.
Manually proofread (read out) your report before submission.
3

Please follow the instructions in the cover sheet and make sure to avoid plagiarism. Also, use APA style for references.