Interview challenge
Pyramidia Ventures
Interview Challenge – Accounting
Admin & Accounting Intern
Prepare the following challenge and send your report in Excel to [email protected]
You are the Accounts Assistant of Pyramidia Ventues Ltd. You are tasked with preparing the periodic Financial Statements.
In any cases where the information is incomplete (indicated with a ?), you’ll have to make and cite your assumptions explicitly.
1. Prepare 12-months of monthly financials, from July 2023 to June 2024.
2. Prepare an Income statement for the year and Opening and Closing Balance sheet for the end of June 2024.
The below information is available. Highlight any concerns or comments
Item
Items as of July 2023
%
Assumptions
Sales of Tomatoes
Ksh800,000
Growing at 5% per month
Sales of Leafy Greens
Ksh500,000
Growing at 8% per month
Rent of sales branches
Ksh10,000
Constant monthly
Salaries
Ksh150,000
Growing by 5,000 every month
Sales & Marketing cost
Ksh80,000
Growing the same as sales volume growth
Other admin
Ksh40,000
Growing at 2% monthly
Gross Margin on Tomatoes
26%
As of January, GM improves to 28%
Gross Margin on Leafy Greens
24%
As of January, GM improves to 26%
Long-term bank debt
Ksh5,000,000
5-year term loan with annual principal repayment in January
Interest on debt
?
Payable monthly. Please suggest interest rate
Purchase of new car
?
Buy 1 small car in the coming year. Please suggest price and how to finance
Electricity and water
Ksh15,000
2%
Monthly bill, rising at 2% per month
Current assets
Ksh3,400,000
Current liabilities
Ksh500,000
Property, plant & equipment
Ksh6,000,000
Accumulated depreciation
Ksh900,000
Financial year depreciation
Ksh300,000
Stockholder equity
Ksh3,000,000
&”Calibri,Regular”&K000000&T_x000D_&D &”Calibri,Regular”&K000000Confidential_x000D_&F &”Calibri,Regular”&K000000Page &P _x000D_of &N
Interested in getting help with this assignment?
Get a professional writing team to work on your assignment!
Order Now
Recent postsFor this final assignment, you will prepare a brief paper detailing the steps undertaken to complete a presentation that disseminates information you assemble
Please choose to answer only one of the 2 following questions. Option 1: In your opinion and based on scientific, peer-reviewed published evidence, does child
At the beginning of the previous academic year, the institution announced it would drop football at the conclusion of the season. The announcement created pub
you will review current research in Personality and provide a critical evaluation of that personality research through an annotated bibliography. An annotated
In Module 5, we considered the third in our three-part series on research design. Specifically, the focus was on the longitudinal studies, in which the resear
Need help with a similar or different Task?
We have the best writers to help you. Hire Writer Now