Sheet1
Star Motor Company
CONSTANTS 2019 2020 2021 2022
TAX RATE NA 0.2 0.2 0.2
MINIMUM CASH NEEDED TO START NEXT YEAR NA 10,000,000 10,000,000 10,000,000
UNIT MANUFACTURING COST REDUCTION FACTOR NA 0.01 0.01 0.01
FIXED COSTS 7,000,000,000 7,000,000,000 7,000,000,000
INPUTS 2019 2020 2021 2022
CREDIT AGENCY RATING (B = WEAK; J = JUNK) J NA NA NA
UNIT CAR SALES INCREASE FACTOR (.XX) NA 0.01 -0.05 -0.09
INCENTIVES (S = STABLE; U = UP) NA S S U
SUMMARY OF KEY RESULTS 2019 2020 2021 2022
NET INCOME AFTER TAXES NA ? [1 mark] copy & paste copy & paste
END-OF-THE-YEAR CASH ON HAND NA ? [2 marks] copy & paste copy & paste
END-OF-THE-YEAR DEBT OWED NA ? [2 marks] copy & paste copy & paste
CALCULATIONS 2019 2020 2021 2022
INTEREST RATE ON DEBT NA ? [2 marks] copy & paste copy & paste
AVERAGE NUMBER OF CAR UNITS SOLD 2125000 ? [3 marks] copy & paste copy & paste
AVERAGE SELLING PRICE PER UNIT 18700 ? [3 marks] copy & paste copy & paste
AVERAGE COST TO MAKE A CAR UNIT 15000 ? [3 marks] copy & paste copy & paste
INTEREST EARNED PER UNIT SOLD NA ? [2 marks] copy & paste copy & paste
INCOME STATEMENT AND
CASH FLOW STATEMENT 2019 2020 2021 2022
BEGINNING-OF-THE-YEAR CASH ON HAND NA ? [1 mark] copy & paste copy & paste
REVENUE — — —
AUTO SALES NA ? [1 marks] copy & paste copy & paste
INTEREST EARNED NA ? [1 marks] copy & paste copy & paste
TOTAL REVENUE NA ? [1 marks] copy & paste copy & paste
COSTS — — —
COST OF AUTOS SOLD NA ? [1 marks] copy & paste copy & paste
FIXED COSTS NA ? [1 mark] copy & paste copy & paste
TOTAL COSTS NA ? [1 mark] copy & paste copy & paste
INCOME BEFORE INTEREST AND TAX NA ? [1 mark] copy & paste copy & paste
INTEREST EXPENSE NA ? [1 marks] copy & paste copy & paste
INCOME BEFORE TAX NA ? [1 mark] copy & paste copy & paste
INCOME TAX EXPENSE NA ? [2 marks] copy & paste copy & paste
NET INCOME AFTER TAX NA ? [1 mark] copy & paste copy & paste
NET CASH POSITION (NCP) BEFORE
BORROWING AND REPAYMENT OF
DEBT (BEG OF YR CASH + NET INCOME) NA ? [1 marks] copy & paste copy & paste
ADD: BORROWING FROM BANK NA ? [2.5 marks] copy & paste copy & paste
LESS: REPAYMENT TO BANK NA ? [5 marks] copy & paste copy & paste
EQUALS: END-OF-THE-YEAR CASH ON HAND 10,000,000 ? [2 marks] copy & paste copy & paste
DEBT OWED 2019 2020 2021 2022
BEGINNING-OF-THE-YEAR DEBT OWED NA ? [0.5 mark] copy & paste copy & paste
ADD: BORROWING FROM BANK NA ? [0.5 mark] copy & paste copy & paste
LESS: REPAYMENT TO BANK NA ? [0.5 mark] copy & paste copy & paste
EQUALS: END-OF-THE-YEAR DEBT OWED 20,000,000,000 ? [2 marks] copy & paste copy & paste
Sheet2
Sheet3