Excel Spreadsheet has been attached to the files. Please fill in answers for the yellow shaded areas and make sure to follow the instructions as to rounding.
1.-Please follow attached instructions.
2.-I attached an example to mirror
3.-I am providing Eli Lilly Income statements, Proxy report, 10K, Executive compensation, ESG data 2021, and this link to obtain news in regards to products. https://investor.lilly.com/
Please see attached guidelines and rubric.
I have also attached workbook and Final Project Scenario Document.
Subject: Accounting and Finance
Word count: 2500
– font Calibri
– in 12 point size font
– using double spacing
– using 2.54cm (1 inch) margins.
– Harvard referencing
Complete requirements 4 through 10 of the Jane’s Skateboards for the second milestone of the course project.
For this Discussion, please view the following video on Financial Shenanigans, read the following article about Joseph Wells, the Godfather of Fraud, and research the ACFE:
Financial Shenanigans – link: https://www.youtube.com/watch?v=Zg-led5YMlo
The Decisions of a Fraud Fighter – link: https://www.fraud-magazine.com/article.aspx?id=4294969187
About the ACFE – link: https://www.acfe.com/about-the-acfe.aspx
What are your impressions from the video, article, and website. What did you learn that was new? Were you able to relate to anything from your own experiences at work?
Reply to classmates post on why you agree with them:
Post By Kevin Wagner:
“There are many forms of “white collar” crime. We hear of people manipulating figures on their financial reports in an attempt to manipulate investors. Usually a company will inflate their numbers so that their company looks more successful to make investors feel more confident in investing large amounts of money. There have also been many high-profile cases of people embezzeling funds for their own personal gain. However, this week for the first time I have learned of a company that deflated their figures. Howard Schilit deflated the numbers on his reports. The most obvious reason I can think of to do this is to hide earnings now, to report them later (YouTube, 2020). The hidden funds could be added to reports later after a move the company makes in an effort to make that move look more successful. A company could possibly pick their moment to appear to be at their strongest. This could also be done at the end of the year to make year-end reports look strong.
YouTube. (2020). Financial Shenanigans (By Howard Schilit). YouTube. Retrieved September 16, 2022, from https://www.youtube.com/watch?v=Zg-led5YMlo. “
FASB Lease update ASU_2021-05.pdf Write a summary of the document you have selected. Your paper should include such information as:
An explanation of the issues discussed in the document,
The FASB position on the issue including the FASB arguments supporting their position,
Discuss any opposing positions (review the comment letters as a source)
Discuss your position for or against the FASB position and explain why
Case Analysis Requirements:
Based on your readings and peer reviewed literature complete this assignment
The body of this paper should be 2-3 pages (not including cover page, abstract or references) but not more than 4 pages.
This research paper requires a minimum of two scholarly references: academic journals, professional journals, and/or appropriate authoritative references such as FASB Codification System, COSO, COBIT, Audit Standards, etc.
Be sure to provide specific examples throughout your paper to back up your statements
Go to the website of any public company and review their (consolidated) financial statements. Review the financial statement and footnote presentation for their leases. Discuss and evaluate their reporting for leases based on professional standards in a presentation. include the financial statements as components of your presentation
Which of the following do you think a city should report as an “extraordinary” or a “special” item assuming that they are material in amount:
The settlement of an age discrimination lawsuit
The sale, at a sizable gain, of city‐owned land to a private developer
The unreimbursed cost of providing housing and other assistance to hurricane victims who have relocated from other areas
A major donation, which the city had actively solicited from a local corporation to support a city science center
According to the GASB, “Financial statements for governmental funds should be presented using the current financial resources measurement focus and the modified accrual basis of accounting.” Financial resources are conventionally defined as “cash, investments, and receivables, and other assets that can be expected to be transformed into cash in the normal course of operations.” Included among the assets of governmental funds are supplies inventories and prepaid items, such as insurance and rent. Yet neither of these appear to meet the definition of financial resources. In your opinion, should these items be reported on the balance sheets of governmental funds? In light of the conventional definition of financial resources, how can including them be justified?
You are the auditor of a state. The state made a $10 million grant to a city. The grant reimburses the city for allowable costs incurred in hosting a meeting of international leaders. The meeting was held two weeks prior to the end of the state’s fiscal year, but as of the end of the fiscal year the city had not yet submitted documentation of any costs incurred. The state comptroller asserts that no amount of the grant should be reported as an expenditure of the current year in that the state has no reliable information as to the actual amount of allowable costs incurred and that are thereby eligible for reimbursement. Do you agree with the comptroller?
A city on the coast of Florida has incurred losses (including impairment of assets, clean‐up costs, additional public safety costs, etc.) of $50 million owing to a recent hurricane. This was the third time in as many years in which the city was hit by major storms. Should the losses be classified as “extraordinary”?
Project – Conch Republic Electronics
You will find an Excel spreadsheet to be the most effective way of completing this assignment. Use the attached Conch Republic Spreadsheet to help you.
Conch Republic Electronics is a mid sized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years ago, the company originally repaired radios and other household appliances. Over the years, the company expanded into manufacturing and is now a reputable manufacturer of various electronic items. Jay McCanless, a recent MBA graduate, has been hired by the company’s finance department.
One of the major revenue-producing items manufactured by Conch Republic is a personal digital assistant (PDA). Conch Republic currently has one PDA model on the market, and sales have been excellent. The PDA is a unique item in that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly, and the current PDA has limited features in comparison with newer models. Conch Republic developed a prototype for a new PDA that has all the features of the existing PDA but adds new features such as cell phone capability. The company has performed a marketing study to determine the expected sales figures for the new PDA.
Conch Republic can manufacture the new PDA for $200 each in variable costs. Fixed costs for the operation are estimated to run $4.5 million per year. The estimated sales volume is 70,000, 80,000, 100,000, 85,000, and 75,000 per each year for the next five years, respectively. The unit price of the new PDA will be $340. The necessary equipment can be purchased for $16.5 million and will be depreciated on a 5 year straight-line schedule.
Net working capital investment for the PDAs will be $6,000,000 the first year of operations. Of course NWC will be recovered at the projects end. Conch Republic has a 35 percent corporate tax rate and a 12 percent required return.
Shelly has asked Jay to prepare a report that answers the following questions:
What is the IRR of the project?
What is the NPV of the project, based on the required rate of return of 12%?