Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Name Price Promo Budget Sales Budget Benchmark Prediction Your Forecast Gross Revenue Variable Costs Contrib Margin Less Promo/Sales Able $ 29.00 $ 1,600 $ 2,082

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Name Price Promo Budget Sales Budget Benchmark Prediction Your Forecast Gross Revenue Variable Costs Contrib Margin Less Promo/Sales Able $ 29.00 $ 1,600 $ 2,082 2,381 0 $ 69,046 $ 40,979 $ 28,068 $ 24,386 Acre $ 20.00 $ 2,000 $ 1,909 3,169 0 $ 63,390 $ 33,970 $ 29,419 $ 25,511 Adam $ 39.00 $ 1,400 $ 1,735 632 0 $ 24,640 $ 15,999 $ 8,641 $ 5,506 Aft S 34.00 $ 1,400 $ 1,475 886 0 $ 30,136 $ 22,980 $ 7,156 $ 4,281 S 34.50 $ 1,400 $ 1,475 848 0 $ 29,244 $ 19,502 $9,742 $ 6,868 Agape Acre2 $ 20.00 $ 1.000 $ 0 1,251 0 $ 25,025 $ 14,923 $ 10.101 $ 9,101 Able2 $ 0.00 $0 $ 0 0 0 $0 $ 0 So $ 0 NA $0.0 $0 $0 0 $ 0 $ 0 $0 $0 Total $ 8,800 $ 8,676 9,167 0 $ 241,481 $ 148,353 $ 93,128 $ 75,653 A/R Lag (days) 0:1 30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast 75 $69,047 $63,390 3,169 50 2,381 Revenue forecast (in 000's) $30,136 $29,245 $24,640 $25,024 1,251 886 848 632 0 0 $0 Able2 Able Acre Adam Aft Agape Acre2 Able Acre Adam Aft Agape Acre2 Able2 Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Company Close Change EPS Dividend Yield PIE Andrews Baldwin Chester Digby Erie Ferris $40.35 $37.77 $44.56 $39.79 $38.78 $45.41 $0.27 ($5.94) $6.14 $2.06 ($0.39) $3.86 Stock Market Summary MarketCap Book Value Shares ($M) Per Share 2,874,035 $116 $31.39 2,000,000 $76 $24.51 2,159,081 $96 $29.28 2,095,724 $83 $25.63 2,128,085 $83 $26.97 2,000,000 $91 $24.93 $1.62 $1.21 $3.56 $2.46 $1.97 $3.27 $0.00 $2.42 $0.87 $0.00 $1.69 $1.52 0.0% 6.4% 1.9% 0.0% 4.4% 3.3% 24.9 31.2 12.5 16.2 19.6 13.9 Closing Stock Price C130387_002 S60 . 550 Andrews Baldwin + Chester Digby Erie Ferris $40 $30 S20 S10 so 2021 2022 2023 2024 2025 2026 2027 2028 2029 Bond Market Summary Company Series# Face Yield Close $ S&P Andrews 12.5S2025 14.0S2027 11.352032 11.8S2033 $13,900,000 $20,850,000 $18,900,000 $11,000,000 12.4% 13.2% 11.7% 11.9% 100.84 106.08 96.27 98.87 wwww Baldwin 12.5S2025 14.0S2027 12.5S2033 $13,900,000 $20,850,000 $567,420 12.6% 13.7% 13.0% 98.83 102.37 96.23 CC CC CC Chester BB 12.5S2025 14.0S2027 $10,263,580 $20,850,000 12.3% 13.0% 101.70 107.67 BB Digby 12.5S2025 14.0S2027 11.352032 12.882033 $13,900,000 $20,850,000 $1,048,582 $9,873,264 12.7% 13.7% 12.6% 13.2% 98.67 102.07 89.85 97.32 CC CC CC CC Erie 12.5S2025 14.0S2027 11.752033 $13,900,000 $20,850,000 $1,869,493 12.5% 13.4% 12.2% 100.17 104.82 96.11 B B B Ferris 12.5S2025 14.0S2027 $4,405,473 $20,850,000 12.5% 13.3% 100.34 105.13 B B Next Year's Prime Rate 8.00% Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $38,664 $15,378 $6,315 $60,358 Baldwin $28,163 $8,670 $14,582 $51,415 Chester $19,158 $10,868 $11,220 $41,245 Digby $29,822 $11,221 $14,597 $55,639 Erie $24,175 $8,551 $8,718 $41,444 Ferris $19,831 $10,144 $14,555 $44,530 Plant and equipment Accumulated Depreciation Total Fixed Assets $162,400 ($49,520) $112,880 $114,700 ($46,247) $68,453 $115,600 ($44,853) $70,747 $126,200 ($45,467) $80,733 $123,818 ($46,928) $76,890 $88,900 ($32,807) $56,093 Total Assets $173,238 $119,868 $111,992 $136,372 $118,334 $100,623 Accounts Payable Current Debt Total Current Liabilities $11,420 $6,950 $18,370 $6,088 $29,438 $35,526 $7,627 $10,030 $17,657 $7,952 $29,034 $36,986 $5,719 $18,600 $24,319 $7,318 $18,195 $25,513 Long Term Debt Total Liabilities $64,650 $83,020 $35,317 $70,844 $31,114 $48,771 $45,672 $82,658 $36,619 $60,938 $25,255 $50,769 Common Stock Retained Earnings Total Equity $51,060 $39,158 $90,218 $18,360 $30,665 $49,024 $23,946 $39,275 $63,221 $21,971 $31,743 $53,714 $22,747 $34,649 $57,396 $18,360 $31,495 $49,855 Total Liabilities & Owners' Equity $173,238 $119,868 $111,992 $136,372 $118,334 $100,623 Income Statement Survey Sales Variable Costs (Labor, Material, Carry) Contribution Margin Depreciation SGA (R&D, Promo, Sales, Admin) Other (Fees, Writeoffs, TQM, Bonuses) EBIT Interest (Short term, Long term) Taxes Profit Sharing Net Profit Andrews $187,105 $133,416 $53,689 $10,133 $25,938 $1,500 $16,117 $8,813 $2,557 $95 $4,653 Baldwin $105,488 $68,963 $36,525 $7,647 $17,044 $38 $11,797 $7,995 $1,331 $49 $2,422 Chester $132,222 $90,823 $41,399 $7,707 $16,324 $119 $17,250 $5,185 $4,223 $157 $7,685 Digby $136,521 $91,875 $44,646 $7,413 $19,126 $681 $17,426 $9,349 $2,827 $105 $5,145 Erie $104,037 $71,047 $32,990 $8,255 $11,794 ($446) $13,388 $6,791 $2,309 $86 $4,202 Ferris $123,414 $84,275 $39,139 $5,927 $18,383 ($775) $15,604 $5,326 $3,597 $134 $6,547 Name Price Promo Budget Sales Budget Benchmark Prediction Your Forecast Gross Revenue Variable Costs Contrib Margin Less Promo/Sales Able $ 29.00 $ 1,600 $ 2,082 2,381 0 $ 69,046 $ 40,979 $ 28,068 $ 24,386 Acre $ 20.00 $ 2,000 $ 1,909 3,169 0 $ 63,390 $ 33,970 $ 29,419 $ 25,511 Adam $ 39.00 $ 1,400 $ 1,735 632 0 $ 24,640 $ 15,999 $ 8,641 $ 5,506 Aft S 34.00 $ 1,400 $ 1,475 886 0 $ 30,136 $ 22,980 $ 7,156 $ 4,281 S 34.50 $ 1,400 $ 1,475 848 0 $ 29,244 $ 19,502 $9,742 $ 6,868 Agape Acre2 $ 20.00 $ 1.000 $ 0 1,251 0 $ 25,025 $ 14,923 $ 10.101 $ 9,101 Able2 $ 0.00 $0 $ 0 0 0 $0 $ 0 So $ 0 NA $0.0 $0 $0 0 $ 0 $ 0 $0 $0 Total $ 8,800 $ 8,676 9,167 0 $ 241,481 $ 148,353 $ 93,128 $ 75,653 A/R Lag (days) 0:1 30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast 75 $69,047 $63,390 3,169 50 2,381 Revenue forecast (in 000's) $30,136 $29,245 $24,640 $25,024 1,251 886 848 632 0 0 $0 Able2 Able Acre Adam Aft Agape Acre2 Able Acre Adam Aft Agape Acre2 Able2 Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Company Close Change EPS Dividend Yield PIE Andrews Baldwin Chester Digby Erie Ferris $40.35 $37.77 $44.56 $39.79 $38.78 $45.41 $0.27 ($5.94) $6.14 $2.06 ($0.39) $3.86 Stock Market Summary MarketCap Book Value Shares ($M) Per Share 2,874,035 $116 $31.39 2,000,000 $76 $24.51 2,159,081 $96 $29.28 2,095,724 $83 $25.63 2,128,085 $83 $26.97 2,000,000 $91 $24.93 $1.62 $1.21 $3.56 $2.46 $1.97 $3.27 $0.00 $2.42 $0.87 $0.00 $1.69 $1.52 0.0% 6.4% 1.9% 0.0% 4.4% 3.3% 24.9 31.2 12.5 16.2 19.6 13.9 Closing Stock Price C130387_002 S60 . 550 Andrews Baldwin + Chester Digby Erie Ferris $40 $30 S20 S10 so 2021 2022 2023 2024 2025 2026 2027 2028 2029 Bond Market Summary Company Series# Face Yield Close $ S&P Andrews 12.5S2025 14.0S2027 11.352032 11.8S2033 $13,900,000 $20,850,000 $18,900,000 $11,000,000 12.4% 13.2% 11.7% 11.9% 100.84 106.08 96.27 98.87 wwww Baldwin 12.5S2025 14.0S2027 12.5S2033 $13,900,000 $20,850,000 $567,420 12.6% 13.7% 13.0% 98.83 102.37 96.23 CC CC CC Chester BB 12.5S2025 14.0S2027 $10,263,580 $20,850,000 12.3% 13.0% 101.70 107.67 BB Digby 12.5S2025 14.0S2027 11.352032 12.882033 $13,900,000 $20,850,000 $1,048,582 $9,873,264 12.7% 13.7% 12.6% 13.2% 98.67 102.07 89.85 97.32 CC CC CC CC Erie 12.5S2025 14.0S2027 11.752033 $13,900,000 $20,850,000 $1,869,493 12.5% 13.4% 12.2% 100.17 104.82 96.11 B B B Ferris 12.5S2025 14.0S2027 $4,405,473 $20,850,000 12.5% 13.3% 100.34 105.13 B B Next Year's Prime Rate 8.00% Balance Sheet Survey Cash Accounts Receivable Inventory Total Current Assets Andrews $38,664 $15,378 $6,315 $60,358 Baldwin $28,163 $8,670 $14,582 $51,415 Chester $19,158 $10,868 $11,220 $41,245 Digby $29,822 $11,221 $14,597 $55,639 Erie $24,175 $8,551 $8,718 $41,444 Ferris $19,831 $10,144 $14,555 $44,530 Plant and equipment Accumulated Depreciation Total Fixed Assets $162,400 ($49,520) $112,880 $114,700 ($46,247) $68,453 $115,600 ($44,853) $70,747 $126,200 ($45,467) $80,733 $123,818 ($46,928) $76,890 $88,900 ($32,807) $56,093 Total Assets $173,238 $119,868 $111,992 $136,372 $118,334 $100,623 Accounts Payable Current Debt Total Current Liabilities $11,420 $6,950 $18,370 $6,088 $29,438 $35,526 $7,627 $10,030 $17,657 $7,952 $29,034 $36,986 $5,719 $18,600 $24,319 $7,318 $18,195 $25,513 Long Term Debt Total Liabilities $64,650 $83,020 $35,317 $70,844 $31,114 $48,771 $45,672 $82,658 $36,619 $60,938 $25,255 $50,769 Common Stock Retained Earnings Total Equity $51,060 $39,158 $90,218 $18,360 $30,665 $49,024 $23,946 $39,275 $63,221 $21,971 $31,743 $53,714 $22,747 $34,649 $57,396 $18,360 $31,495 $49,855 Total Liabilities & Owners' Equity $173,238 $119,868 $111,992 $136,372 $118,334 $100,623 Income Statement Survey Sales Variable Costs (Labor, Material, Carry) Contribution Margin Depreciation SGA (R&D, Promo, Sales, Admin) Other (Fees, Writeoffs, TQM, Bonuses) EBIT Interest (Short term, Long term) Taxes Profit Sharing Net Profit Andrews $187,105 $133,416 $53,689 $10,133 $25,938 $1,500 $16,117 $8,813 $2,557 $95 $4,653 Baldwin $105,488 $68,963 $36,525 $7,647 $17,044 $38 $11,797 $7,995 $1,331 $49 $2,422 Chester $132,222 $90,823 $41,399 $7,707 $16,324 $119 $17,250 $5,185 $4,223 $157 $7,685 Digby $136,521 $91,875 $44,646 $7,413 $19,126 $681 $17,426 $9,349 $2,827 $105 $5,145 Erie $104,037 $71,047 $32,990 $8,255 $11,794 ($446) $13,388 $6,791 $2,309 $86 $4,202 Ferris $123,414 $84,275 $39,139 $5,927 $18,383 ($775) $15,604 $5,326 $3,597 $134 $6,547

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Foundations of Finance The Logic and Practice of Financial Management

Authors: Arthur J. Keown, John D. Martin, J. William Petty

8th edition

132994879, 978-0132994873

Students also viewed these Accounting questions