Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

kindly copy and paste this in an excel file please Ey Office 365 Community Ibrahim Timothy 1 BALANCE SHEET (Projections) Assets Cash & Equivalents Accounts

kindly copy and paste this in an excel file please
image text in transcribed
Ey Office 365 Community Ibrahim Timothy 1 BALANCE SHEET (Projections) Assets Cash & Equivalents Accounts Receivable Inventory Deposits Current Assets 0 1,504 1,404 6,000 8,908 2 0 1,011 1,348 6,000 8,359 3 4 5 19,382 72,636 132,119 1,179 1,516 1,685 1,572 2,022 2,246 6,000 6,000 6,000 28,134 82,174 142,050 Fixtures and Interiors Equipment Installations Accumulated Derpeciation Net Fixed Assets Total Assets 20,000 5,000 32,000 11,400 45,600 54,508 20,000 5,000 32,000 22,800 34,200 42,559 20,000 20,000 20,000 5,000 5,000 5,000 32,000 32,000 32,000 34,200 45,600 57,000 22,800 11,400 0 50,934 93,574 142,050 4,889 - 11.393 27,596 21,092 Equity & Liabilities Accounts Payable Defferals Short Term Debt Current Liabilities Long Term Debt Paid up capital R/E Net Equity Total Equity & Liabilities 2,527 - 190 3.903 6,240 3,345 60,000 27.0 32,973 42,559 2.948 4.504 0 7,452 D 60,000 16 518 43,482 50,934 3,791 4,212 13,890 18,584 0 0 17,681 22,796 0 0 60,000 60,000 15,893 59,255 75,893 119,255 93,574 142,050 60,000 26,584 33,416 54,508 22.727 53,254 59,483 Free Cash Flows (FCF) -60,000 3.355 FCF - NOPAT - Net Investments in Operating Assets NOPATEBIT1-Tax Rate)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services A Systematic Approach

Authors: William F. Messier, Steven M. Glover, Douglas F. Prawitt

4th Edition

0071117474, 9780071117470

More Books

Students also viewed these Accounting questions

Question

Describe new developments in the design of pay structures. page 501

Answered: 1 week ago