MoustafaYoussef_1002519
.xlsx
keyboard_arrow_up
School
Fanshawe College *
*We aren’t endorsed by this school
Course
1031
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
31
Uploaded by SuperHumanOstrichMaster911
Do the work IN THIS ORDER !!!
Marks
1) Do income statements for
2021
6
2) Do Balance Sheets for
2021
6
3) Do a pro forma Income Statement for
2022
8
4) Do a pro forma Balance Sheet for
2022
8
5) Do Cash Flow Statement for
2021
10
6) Do ratios for
2020
2021
10
7) Do pro forma Ratios for
2022
5
8) Do a pro forma cash budget for
2022
18
9) Do breakeven questions for 2021
2022
8
10) Do the theory problem below
20
Total
99
Theory Problem
Based on the ratios
AND
common size calculations compare how Fanshawe Furniture is doing compared to the benchmark. Is it doing better or worse ? Be specific. This is worth 20 marks which means you should be comparing 10 sets of numbers and explaining why the numbers are different and whether they are better or worse.
MoustafaYoussef1002519
2021 Data
MoustafaYoussef1002519
2021
Accounts payable
$ 1,030,085 Accounts receivable
$ 483,637 Amortization expense
$ 38,000 Beginning Inventory
$ 760,000 Cash
$ 196,837 Common stock
$ 100,000 Ending Inventory
$ 1,014,034 Freight In
$ 39,660 Interest expense
$ 63,401 GIC's
$ 250,000 Mortgage payable
$ 911,115 Net Purchases
$ 2,993,557 Net Sales
$ 5,253,140 Notes payable
$ 150,000 Prepaid expenses
$ 42,089 Plant and Equipment
$ 3,900,000 Salaries
$ 688,452 Utilities
$ 2,883 Insurance
$ 2,791 Transport
$ 20,698 Repairs & Maintenance
$ 9,589 Advertising
$ 26,814 Misc. Expense
$ 49,705 Direct Wages and Expenses
$ 1,185,500 Comon Stock Dividends
$ 50,000 1002519
2020
MoustafaYoussef1002519
Other Info
2021
2020
2022
Common Stock
400000 shares
400000 shares
400000 shares
Notes Payable
current
Sales on Credit
90% percent of net sales
Share Price
2020 $ 1.60 per share
Share Prices based on accounting department's esti
Share Price
2021 $ 2.75 per share
The directors have decided that no new shares will be issued/sold in 2022
Tax rate
40% Of Net Income
Taxes on the year's profits are paid in December
Amortization Expense
4% declining balance
imates.
Accounts payable
1030085
Accounts receivable
483637.15
Amortization expense
38000
Beginning Inventory
760000
Cash
196837.15
Common stock
100000
Ending Inventory
1014034
Freight In
39660
Interest expense
63401
GIC's
250000
Mortgage payable
911115
Net Purchases
2993557
Net Sales
5253140
Notes payable
150000
Prepaid expenses
42089
Plant and Equipment
3900000
Salaries
688451.92
Utilities
2883.1
Insurance
2790.64
Transport
20698.36
Repairs & Maintenance
9588.55
Advertising
26814.34
Misc. Expense
49705.26
Direct Wages and Expenses
1185500
Comon Stock Dividends
50000
1002519
2020 MoustafaYoussef1002519
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Need solution will rate1
arrow_forward
Use the relevant information contained in the Cash Flow and Income Statement Tabs. Compute the Net Free Cash Flow to Invested Capital for the year 2022. State as a whole number and round to the second decimal place. (i.e. $12,987.654 would be written as 12,987.65). Assume the appropriate tax rate to compute NOPAT is 27%.
arrow_forward
Solve this balance sheet picture by horizontal analysis and write why it's decrease and increase in percentage :
arrow_forward
Define the following with formulaes if possible: Please write full definations.
1. Cash Receipt Budget
2. Short Term Financial Needs
3.Budgeted Income Statement
4. Budgeted Balance Sheet
arrow_forward
the major purpose of which of the following is to prepare an accurate estimate of future
cash flows? A. Operating budget B. Cash budget C. Capital budget D. Executive budget
arrow_forward
3. Trace the implications of a government budget surplus on the following:a. national savingb. interest ratesc. private investmentd. economic growthe. future living standards When tracing the effects of the budget surplus, list the assumptions you are making.
arrow_forward
Explain why it would be beneficial to prepare a cash forecast, or a cash budget, for an organization. (4 sentences)
arrow_forward
KA.
Please answer fast
arrow_forward
explain the picture provided
arrow_forward
Item 1 Which of the following is a budget used to project cash flow and likely cash shortfalls and/or
surpluses? Multiple Choice Financing budget Master budget Rolling budget Operational budget
Capital budget
arrow_forward
Only use Excel please and take a screenshot
arrow_forward
Qw.138.
arrow_forward
Please help me to solve this problem
arrow_forward
Finding the present value of future cash flows is called and finding the future value of present cash flows is called
O A. analytics, tracking
B. capital budgeting, short-term budgeting
C. discounting, compounding
D. financial ratio analysis, financial statement analysis
O E. fundamental analysis, technical analysis
arrow_forward
I just need to know the formulas to input into the NPV along with the 4 NPV formulas on the bottom
arrow_forward
For an accessible version, see the Excel spreadsheet.
Example
Cash and cash
equivalents
Blank 1
Step 1: Blank 1; - Blank 2; = Blank 3;
Step 2: Blank 4; Blank 5; = Blank 6%
Blank 2
Blank 3
...... A
Add your answer
Add your answer
Add your answer
2022
AddrawUE
$330
Calculate the 2022 Horizontal Analysis variance of "Selling and Administrative Expenses" in %. Fill in the equations using the financial
statements provided (no symbols or commas) and the % should be in a XX.XX format:
Last saved 3:49:34 PM
2021
$360
2022 2021 #
-$30
Answer / 2021
-0.083333333
Update to %
-8.30%
arrow_forward
Q3:-what is the difference between budgets and budgeting, Reinforce your answer with examples , dates, and equations:-
arrow_forward
Define each of the following terms:f. Cash budget; target cash balance
arrow_forward
A method of budgeting that estimates todays value of money to be received in the future; it is discounted due to the uncertainty of its true value in the future and for the cost of the capital is______________.
Select one:
a. Discounted cash flow.
b. Payback period
c. None of the options
d. Cash inflow.
e. Cash outflow.
Clear my choice
arrow_forward
This method consists of taking the estimated statement of income for the next period and adding or subtracting to the profit or loss the items affecting cash that are not included as sales or expenses.
This definition corresponds to the method:
(Choose one option)
A) of the budgeted income statement
B) projected balance sheet
C) cash inflows and outflows
D) contemporaneous cash planning method
arrow_forward
EXERCISE 3: CASH INFLOWS AND CASH OUTFLOWS
With the following capital budgetng elements, identify the cash outflows and cash
inflows that you would use to judge the attractiveness of a project by using the time-
value-of money yardstıcks capital assets ($1.5 million), working capital in year 1
($500,000) and year 2 ($200,000), salaries ($140,000), working capital loan ($190,000).
residual value at the end of the 11th year ($1 million), profit for the years 1 to 10
($300,000), mortgage ($1.1 million), non-cash expense ($50,000), revenue ($300,000),
and sunk costs ($100,000). The project's lifespan is 10 years and the cost of capital is
8%.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Need solution will rate1arrow_forwardUse the relevant information contained in the Cash Flow and Income Statement Tabs. Compute the Net Free Cash Flow to Invested Capital for the year 2022. State as a whole number and round to the second decimal place. (i.e. $12,987.654 would be written as 12,987.65). Assume the appropriate tax rate to compute NOPAT is 27%.arrow_forwardSolve this balance sheet picture by horizontal analysis and write why it's decrease and increase in percentage :arrow_forward
- Define the following with formulaes if possible: Please write full definations. 1. Cash Receipt Budget 2. Short Term Financial Needs 3.Budgeted Income Statement 4. Budgeted Balance Sheetarrow_forwardthe major purpose of which of the following is to prepare an accurate estimate of future cash flows? A. Operating budget B. Cash budget C. Capital budget D. Executive budgetarrow_forward3. Trace the implications of a government budget surplus on the following:a. national savingb. interest ratesc. private investmentd. economic growthe. future living standards When tracing the effects of the budget surplus, list the assumptions you are making.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you