Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
help with the sources and uses spreadsheet. i need the formulas for imputing the sources and uses/ where the numbers are coming from. The finished
help with the sources and uses spreadsheet. i need the formulas for imputing the sources and uses/ where the numbers are coming from. The finished sources and uses should look similar to the blank. thank you! 2006 Sales COGS Expenses Depreciation EBIT Interest Expense Taxable income 2007 $12,000 $6,600 $1,740 $315 $3,345 $345 $3,000 $1,200 $1,800 Taxes Net Income Plowback ratio Dividend payout Market Price - 2007 Number of Shares Dividends EPS $4.88 $1.71 65% 35% $41 369 $631 $1,170 $16.00 Dividends per share Contribution to RE Book Price Cash AR Inventory Other CA 2006 2007 $100 $126 $992 $1,045 $361 $355 $264 $303 $1,717 $1,829 $8,835 $10,410 $945 $1,260 $7,890 $9,150 $9,607 $10,979 Total CA GFA Acc Depr Net FA Total Assets C D E F Net Income $1,800 EPS $4.88 $1.71 G Dividend payout Market Price - 2007 Number of Shares Dividends Contribution to RE Book Price H 35% $41 369 $631 $1,170 $16.00 Dividends per share Cash AR Inventory Other CA 2006 2007 $100 $126 $992 $1,045 $361 $355 $264 $303 $1,717 $1,829 $8,835 $10,410 $945 $1,260 $7,890 $9,150 $9,607 $10,979 Total CA GFA Acc. Depr Net FA Total Assets A/P N/P Other CL Total CL LT Debt $303 $119 $1,353 $1,775 $4,332 $4,130 -$630 $3,500 $9,607 $340 $135 $1,150 $1,625 $3,454 $4,730 $1,170 $5,900 $10,979 CS RE Equity TL&NW wir Problem Evanded prob Sources and uses D E F G H Calculate the Sources and Uses and the % 2006-2007 Sources Cash A/R Inventory Other CA GFA Acc. Depr A/P N/P Other CL LT Debt CS RE $ $0 Uses Cash AR Inventory Other CA GFA Acc. Depr A/P N/P Other CL LT Debt CS RE Expanded Prob. Sources and uses + Calculate the Sources and Uses and the % 2006-2007 Sources Cash AR Inventory Other CA GFA Acc. Depx AJP N/P Other CL LT Debt CS RE $0 SO $6 SO $0 $315 $37 $16 $0 $0 $1.231 $1.169 $2,774 % 0% 0% 0% 0% 0% 11% 1% 1% 0% 0% 44% 42% 100.00% Uses Cash AVR Inventory Other CA GFA Acc. Depr. AJP N/P Other CL LT Debt CS RE $26 $53 SO $39 $1,575 SO $0 $0 $203 $878 SO $0 $2,774 1% 2% 0% 1% 57% 0% 0% 0% 7% 32% 0% 0% 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started