I am only looking to figure how to set up the problem in excel, I don't need anyone to solve for the actual answer. How do I set up the problem correctly in excel?

Apply FASB Topic 606 Revenue from Contracts with Customers

Cost of goods sold is 70% of revenue

Stand-alone selling prices in the bundle are: hardware & software $500 | services $250 | software upgrades $250

Show the accounting for selling only 1 iPhone to answer the following questions:

-Based on the $800 bundled sales price, show how accounting for one performance obligation impacts the current and two future years income statement, balance sheet, and statement of cash flows. Show the financial statements.

-Based on the $800 bundled sales price, show how accounting for three performance obligation impacts the current and two future years income statement, balance sheet, and statement of cash flows. Show the financial statements