Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PROFORMA ASSUMPTIONS: Below is Athleta's financial statements for 2018 and 2019. Proforma year is 2020. Athleta expects that sales in 2020 will increase by 13

image text in transcribed
image text in transcribed
image text in transcribed
PROFORMA ASSUMPTIONS: Below is Athleta's financial statements for 2018 and 2019. Proforma year is 2020. Athleta expects that sales in 2020 will increase by 13 percent. The company is planning to expand its operations to new cities in 2020. - For the planned expansion, Athleta received $1,700 additional long-term loan from J.P. Morgan Chase and will use this loan to finance the purchase of a new office building. - Salaries are expected be $113. - The market conditions will lead COGS will be 10 percent lower than the 2019 level. - When proiecting the 2020 balance sheet. Athleta believed that the accounts receivable days will be 7 days higher than ACP days of last vear. - Inventory days will remain unchanged from 2019 - Accounts payable dollar amount will remain unchanged from 2019 since the business has recently been rewarded with extended payment terms from its suppliers qoing forward. - Current maturities of lonq-term debt (CMLTD), minimum cash ratio (i.e. Cash/NS) and dividend payments will remain same as in 2019. - Tax rate is 14 percent. - Proforma Net Income will be $794. - Interest rate for lonq-term loan in 2020 is projected to be 4 percent. Interest expense on short term debt is delaved until 2021 (this means apply the interest rate only on long-term debt). - Rental expense would be $6 per month. - Depreciation expense would be the same percentage of gross fixed assets as was in 2019. \begin{tabular}{|lrr|} \hline INCOME STATEMENT & 2018 & 2019 \\ Net sales & 1,316 & 1,658 \\ Cost of goods sold & 332 & 673 \\ Salaries & 90 & 100 \\ Rental expenses & 26 & 18 \\ Depr. Expense & 12 & 30 \\ Interest expense & 560 & 338 \\ Tax expense & 48 & 71 \\ Net income (loss) & 248 & 428 \\ & & \\ \hline BALANCE SHEET & & \\ Cash & 2018 & 2019 \\ Accounts receivable & 26 & 20 \\ Inventory & 72 & 82 \\ Total Current Assets & 85 & 78 \\ GFA & 183 & 180 \\ Accd depre & 1,138 & 1,575 \\ Net fixed assets & 110 & 140 \\ Total Assets & 1,028 & 1,435 \\ Accounts payable & 1,211 & 1,615 \\ Bank line of credit & 39 & 52 \\ Current portion due on term loan & 0 & 225 \\ Total Current Liabilities & 70 & 70 \\ Long-term debt & 109 & 347 \\ Total Liabilities & 875 & 805 \\ Total equity & 984 & 1,152 \\ Total Liabilities and Equity & 227 & 463 \\ \hline \end{tabular} What is proforma accounts receivable in 2020? 99 109 149 129 Hide hint for Question 11 1. Find ACP days first ACP days (2019)=AR(2019)365/NS(2019) 2. Find ACP(2020) using the assumption in the question. Then find AR(2020)=ACP days (2020)NS(2020)/365

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

Before You Buy The Homebuyers Handbook For Todays Market

Authors: Michael Corbett, Jim Gillespie

1st Edition

0452296803, 978-0452296800

More Books

Students also viewed these Finance questions