Create a model that projects the balance sheet and income statement for years 2021 through 2025 as follows Please note the following Use the average balance of LT Debt and LOC to calculate the interest expense For the purpose of calculating average balance, assume average balance equals previous years balance plus current year balance divided by 2 DSO, DSI and DPO are defined as DSO A R (Sales 365 days) DSI Inventory (COGS 365 days) DPO A P (COGS 365 days) Also, we assume that 2020 is the most recently completed historical year Please note, I would like the balance sheet (i e A L E) to balance each year Use Marketable Securities on the Asset side and Line of Credit (LOC) on the L E side of the Balance Sheet as your plug accounts to make the Balance Sheet balance each year 10 0 11 0 12 0 12 5 12 5 60 0 60 0 60 0 60 0 60 0 25 0 25 0 25 0 25 0 25 0 2 0 2 0 2 0 2 0 2 0 $50,000 $50,000 $50,000 $50,000 $50,000 30 0 30 0 30 0 30 0 30 0 10 0 10 0 10 0 10 0 10 0 30 0 30 0 30 0 30 0 30 0 8 0 8 0 8 0 8 0 8 0 7 0 7 0 7 0 7 0 7 0 25 25 25 25 25 30 30 30 30 30 45 45 45 45 45 68 0 8 4 10 0 11 0 12 0 12 5 12 5 60 0 60 0 60 0 60 0 60 0 25 0 25 0 25 0 25 0 25 0 2 0 2 0 2 0 2 0 2 0 $50,000 $50,000 $50,000 $50,000 $50,000 30 0 30 0 30 0 30 0 30 0 10 0 10 0 10 0 10 0 10 0 30 0 30 0 30 0 30 0 30 0 8 0 8 0 8 0 8 0 8 0 7 0 7 0 7 0 7 0 7 0 25 25 25 25 25 30 30 30 30 30 45 45 45 45 45 68 0 8 4

The Answer is in the image, click to view ...

Question: Create a model that projects the balance sheet and income statement for years 2021 through 2025 as follows: Please note the following: Use the average

Create a model that projects the balance sheet and income statement for years 2021 through 2025 as follows:

Create a model that projects the balance sheet and income statement for

Please note the following:

Use the average balance of LT Debt and LOC to calculate the interest expense. For the purpose of calculating average balance, assume average balance equals previous years balance plus current year balance divided by 2.
DSO, DSI and DPO are defined as:
1. DSO = A/R/(Sales/365 days)
2. DSI = Inventory/(COGS/365 days)
3. DPO = A/P/(COGS/365 days)
Also, we assume that 2020 is the most recently completed historical year. Please note, I would like the balance sheet (i.e. A=L+E) to balance each year. Use Marketable Securities on the Asset side and Line of Credit (LOC) on the L + E side of the Balance Sheet as your plug accounts to make the Balance Sheet balance each year.

10.0% 11.0% 12.0% 12.5% 12.5% 60.0% 60.0% 60.0% 60.0% 60.0% 25.0% 25.0% 25.0% 25.0% 25.0% 2.0% 2.0% 2.0% 2.0% 2.0% $50,000 $50,000 $50,000 $50,000 $50,000 30.0% 30.0% 30.0% 30.0% 30.0% 10.0% 10.0% 10.0% 10.0% 10.0% 30.0% 30.0% 30.0% 30.0% 30.0% 8.0% 8.0% 8.0% 8.0% 8.0% 7.0% 7.0% 7.0% 7.0% 7.0% 25 25 25 25 25 30 30 30 30 30 45 45 45 45 45 68 0 8 4 10.0% 11.0% 12.0% 12.5% 12.5% 60.0% 60.0% 60.0% 60.0% 60.0% 25.0% 25.0% 25.0% 25.0% 25.0% 2.0% 2.0% 2.0% 2.0% 2.0% $50,000 $50,000 $50,000 $50,000 $50,000 30.0% 30.0% 30.0% 30.0% 30.0% 10.0% 10.0% 10.0% 10.0% 10.0% 30.0% 30.0% 30.0% 30.0% 30.0% 8.0% 8.0% 8.0% 8.0% 8.0% 7.0% 7.0% 7.0% 7.0% 7.0% 25 25 25 25 25 30 30 30 30 30 45 45 45 45 45 68 0 8 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Match the following concepts. Group of answer choices Consult your loved ones [ Choose ] Line up sympathetic interest groups, who can support with a show in numbers Whistle blowing is a family...

The audit senior provides you with the companys audited balance sheet and income statement for years 2021, 2020, and 2019 and client detail of monthly sales over this same period. please determine if...

Paragraph Save temporarily stored on your computer. Question 4 Huonville Pty Ltd is a newly established company specialised in rug trading. Currently, Huonville has two retail shops and one warehouse...

Hilton Worldwide Holdings Inc. "Hilton is one of the largest and fastest growing hospitality companies in the world, with 6,110 properties comprising 971,780 rooms in 119 countries and territories as...

CASE # 4 ASSIGNMENT: PRO FORMA You are a professional accountant who has been employed to offer advice to a small start up biotech company with the following details given by the client in the first...

Question 4 Huonville Pty Ltd is a newly established company specialised in rug trading. Currently, Huonville has two retail shops and one warehouse for storage. The company commences its trading on 1...

BFA507 The Accounting Framework SECTION B - PRACTICAL QUESTION'S This section contains TWO (2) practical questions with sub-questions. You must attempt ALL questions. Question 4 Huonville Pty Ltd is...

Huonville Pty Ltd is a newly established company specialised in rug trading. Currently, June 18 Paid wages of $10 000 to employees, out of which $3 000 was for Huonville has two retail shops and one...

1.Suppose a riskless project requires an initial investment of $10 and will generate a one-time cash inflow of $30 two years later. Assuming a risk-free interest rate of 5%, which of the following...

Distinguish between internal and external auditors.

Use the information in the adjusted trial balance reported in Exercise 4-4 to compute the current ratio as of the balance sheet date (round the ratio to two decimals). Interpret the current ratio for...

Subsequent to acquisition, when a subsidiary acquires its own outstanding noncontrolling interest shares, credit to the parent's additional paid - in capital is needed whenever the cash paid to...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...