Need help with 1 and 3 Not sure how to make the projection for 1 Is there supposed to be formulas for it or hard code And 3 not sure how to create the if statements Where would I put them Thia chapter 7 lesson 05 INCOME STATEMENT Mosthi Month 2 Look at figure 7 5 on page 16d in the textbook Building Financial Models Revenue 1400 Note Berra highlighted in green differ from the best codd cast of goods sold Sea sales, general, and administrative expenses 510 TOO ES SUMIE4 EST EdiT earnings before interest and trust interest Excess cash Note Interest rate previous month's excess cash balance interest Revolver Note Interest rate previous month's revolver balance interest Debt 60N 54510'024 Note interest rate previous month's debt balance 918 50 8 edT cornings before bases Note Tax tax rate EBT 10 1 Note This assurran o flattax rate BALANCE SHEET Tothi Month 2 Excess cash Current assets 240 0 250 0 Long term Stress Total assets 930 0 6750 SUM LIB LIC Revolver MINIMO Common stock 140 0 Betulned combs FIOS 026 014 Note add last month's RE to this month's Ni, Total links and equity 950 0 Balance sheet check Note The difference between totell ussets and total abilities and equity should be equal to are Assets who cocess cash GUM TIP 13CI Note wo mars without Uabs, equity wo revolver Note labs means liabilities or debt BE Excess cash (revolverThia chapter 7 lesson 05 INCOME STATEMENT Mosthi Month 2 Look at figure 7 5 on page 16d in the textbook Building Financial Models Revenue 1400 Note Berra highlighted in green differ from the best codd cast of goods sold Sea sales, general, and administrative expenses 510 TOO ES SUMIE4 EST EdiT earnings before interest and trust interest Excess cash Note Interest rate previous month's excess cash balance interest Revolver Note Interest rate previous month's revolver balance interest Debt 60N 54510'024 Note interest rate previous month's debt balance 918 50 8 edT cornings before bases Note Tax tax rate EBT 10 1 Note This assurran o flattax rate BALANCE SHEET Tothi Month 2 Excess cash Current assets 240 0 250 0 Long term Stress Total assets 930 0 6750 SUM LIB LIC Revolver MINIMO Common stock 140 0 Betulned combs FIOS 026 014 Note add last month's RE to this month's Ni, Total links and equity 950 0 Balance sheet check Note The difference between totell ussets and total abilities and equity should be equal to are Assets who cocess cash GUM TIP 13CI Note wo mars without Uabs, equity wo revolver Note labs means liabilities or debt BE Excess cash (revolver

Question

Need help with 1 and 3  Not sure how to make the projection for 1  Is there supposed to be formulas for it or hard code  And 3 not sure how to create the if statements  Where would I put them  Thia chapter 7 lesson 05 INCOME STATEMENT Mosthi Month 2 Look at figure 7 5 on page 16d in the textbook  Building Financial Models   Revenue 1400 Note  Berra highlighted in green differ from the best  codd cast of goods sold Sea   sales, general, and administrative expenses 510 TOO ES SUMIE4 EST EdiT   earnings before interest and trust interest Excess cash Note  Interest rate   previous month's excess cash balance interest Revolver Note  Interest rate   previous month's revolver balance interest Debt 60N  54510'024 Note interest rate   previous month's debt balance 918 50 8 edT   cornings before bases Note  Tax   tax rate   EBT 10 1 Note  This assurran o flattax rate BALANCE SHEET Tothi Month 2 Excess cash Current assets 240 0 250 0 Long term Stress Total assets 930 0 6750 SUM LIB LIC Revolver  MINIMO Common stock 140 0 Betulned combs FIOS  026 014 Note  add last month's RE to this month's Ni, Total links and equity 950 0 Balance sheet check Note  The difference between totell ussets and total abilities and equity should be equal to are Assets who cocess cash GUM TIP 13CI Note  wo mars  without  Uabs, equity wo revolver Note  labs means  liabilities   or  debt BE Excess cash (revolverThia chapter 7 lesson 05 INCOME STATEMENT Mosthi Month 2 Look at figure 7 5 on page 16d in the textbook  Building Financial Models   Revenue 1400 Note  Berra highlighted in green differ from the best  codd cast of goods sold Sea   sales, general, and administrative expenses 510 TOO ES SUMIE4 EST EdiT   earnings before interest and trust interest Excess cash Note  Interest rate   previous month's excess cash balance interest Revolver Note  Interest rate   previous month's revolver balance interest Debt 60N  54510'024 Note interest rate   previous month's debt balance 918 50 8 edT   cornings before bases Note  Tax   tax rate   EBT 10 1 Note  This assurran o flattax rate BALANCE SHEET Tothi Month 2 Excess cash Current assets 240 0 250 0 Long term Stress Total assets 930 0 6750 SUM LIB LIC Revolver  MINIMO Common stock 140 0 Betulned combs FIOS  026 014 Note  add last month's RE to this month's Ni, Total links and equity 950 0 Balance sheet check Note  The difference between totell ussets and total abilities and equity should be equal to are Assets who cocess cash GUM TIP 13CI Note  wo mars  without  Uabs, equity wo revolver Note  labs means  liabilities   or  debt BE Excess cash (revolver

Accepted Answer

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

Question

Need help with 1 and 3. Not sure how to make the projection for 1. Is there supposed to be formulas for it or hard

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Business Law

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question