Internal revenue service (IRS).

Exercise 1: Individual Assignment 1. Input the IRS Schedules C from the 2013–2015 income tax returns into a spreadsheet. a. Add percent columns to the right of dollar column for each year. b. Calculate common-sized percentages in the percent columns [divideeach number for that year (e.g., 2013) by gross receipts for that year (e.g., 2013)]. c. Review the dollars horizontally across the three years and vertically down each year and identify any material irregularities. d. Review the percentages horizontally across the three years and vertically down each year and identify any material irregularities. e. Are there any material trends or material single-year changes (e.g., material increases or decreases)? 2. Input the other metrics from the individual tax returns (e.g., income from wages and salaries, interest earned, and estimated tax payments). a. Review the dollars horizontally across the three years and vertically down each year and identify any material irregularities. b. Compareestimatedtaxpaymentswithtotaltaxesfortheyear(vertically during the same year). c. Are there any material trends or material single-year changes (e.g., material increases or decreases)? 3. Because you did not observe the inventory, which was destroyed in the fire, estimate ending inventory using the 2013 and 2014 dollars and percentages (Method #1: Cost of goods sold to gross receipts ratio). a. Because you did not observe the inventory, estimate the ending inventory for 2015 by: i. Averaging the 2013 and 2014 cost of goods sold and 2013 and2014 gross receipts, and then dividing the average cost of goods sold by the average gross receipts. You cannot use an average of an average (e.g., Cost of goods sold/Gross receipts ratios for 2013 and 2014), which can distort the average. You must calculate the averageforeachandthentheCostofgoodssold/Grossreceiptsratio. ii. Multiply the resultant percentage from 3.a.i. by the 2015 gross receipts to get an estimated 2015 cost of goods sold total in dollars. 4. Howdoestheestimatedendinginventoryimpacttheindividualincometaxreturnendinginventory, cost of goods sold, net profit, and net income? Find out by adding an additional column for 2015 and recalculate the cost of goods sold using the estimates calculated above. Every number in that column is identical to the recorded 2015 column except estimated inventory, cost of goods sold, gross profit, and net profit. 5. Compare your recalculated ending inventory to that given to SharptopBank and to Southern Appalachian Insurance. Is either estimated ending inventory materially different from that reported on the 2015 IRS Schedule C? 6. OPTIONAL (extra credit points determined by the professor) Because you did not observe the inventory, which was destroyed in the fire, estimate ending inventory by rolling October 31, 2015, physical inventory totals forward (method #2). a. Starting with October 31, 2015, physical inventory, roll the inventory forward at cost by adding the purchases from November 1, 2015, through December 31, 2015 (according to the various wholesaler purchase records), to the December 31, 2015, physical inventory totals. This results in the inventory available for sale during 2015. b. Then,reducetheinventoryavailableforsalebythesalesfromNovemberand December 2015 Georgia Sales and Use Tax Returns. Note: These sales are at retail price and must be reduced to the wholesale cost. Use the Cost of goods sold/Gross receipts ratio determined in 3.a.i. 7. OPTIONAL (extra credit points determined by the professor) Go to a business library or university librarian and locate RMA Annual Financial Statement Studies or a similar publication and locate convenience stores and comparable ratios (e.g., cost of goods sold to total revenues). How does the cost of goods sold to total receipts ratio in that publication compare to the ratios on the 2015 IRS Schedule C? Exercise 2: Individual Assignment 1. Input information from the SBA Personal Financial Statements given toSharptop Bank into a spreadsheet. a. Separate personal items (e.g., residence) from business items (e.g., inventory). b. Calculate common-sized percentages (divide each number by gross receipts for income statement items and total assets for balance sheet items for that particular year). c. Review the dollars horizontally across the three years and vertically down each year and identify any material irregularities. d. Review the percentages horizontally across the three years and vertically down each year and identify any material irregularities. e. Tracebusinessitems(e.g., accounts payable)to information provided by suppliers (e.g., fuel, groceries, beverage, tobacco, and print media sales summaries). Calculate any differences. f. Compare the reported inventory to the income tax returns and proof of loss (e.g., ending inventory). Calculate any differences. 2. If the tax return or insurance claim is misstated, did Greg Larsen commit some form of financial statement fraud? 3. What accuracy certifications on the tax return and bank financial statement address providing materially inaccurate information? 4. Was Larsen Convenience solvent on January 7, 2016? Solvency is defined three ways: (a) having more assets (particularly current assets) than liabilities (particularly current liabilities), or (b) Larsen Convenience cannot pay its debts when the dates come due, or (c) both (a) and (b). 5. How does Greg Larsen’s business solvency impact his wife Tonya Larsen?