Special Project Template ACC 2302 As of Sept 2023
.docx
keyboard_arrow_up
School
University of Houston, Downtown *
*We aren’t endorsed by this school
Course
2302
Subject
Accounting
Date
Jan 9, 2024
Type
docx
Pages
9
Uploaded by ElderWren1440
Enclosed you will find the project for class, in which you will learn about analysis of financial statements that a manager might perform or utilize. Review Chapter 13 of the textbook as a resource for this assignment. Special Project –
ACC 2302
Fall 2023
Phase 1 & 2
Due Date: Phase 1 - 10/1/23
Phase 2 - 11/13/23
Phase 1 Due October 01, 2023
Worth 40% of the Special Project Grade
Using the Excel template provided, prepare a horizontal income statement and balance sheet for Valero for the years 2019 - 2020. See Exhibits 13.1 and 13.2 for an example. (Ten % of grade)
Using the Excel template provided, prepare a common size income statement and balance sheet for the years 2018-2019 for both Valero. (Ten % of Grade)
o
The income statement common size factor, i.e., the 100% base amount, shall be based upon sales. See Exhibit 13.9 for an example. o
The balance sheet common size factor shall be based upon total assets. See Exhibit 13.8 of the textbook for an example.
Using the Excel template provided, complete the ratio analysis for each item requested. (20% of grade).
Note: Upon completion of the assignment, a survey will be sent to each group regarding the participation of each member of the group. Lack of participation by a group member will affect grades.
Phase 2 – Due 11/13/2023 Step 1 – Solvency & Working Capital Management
Imagine you are reporting to management on the performance of these respective companies. Using the financials statements and the ratios you just calculated, please prepare your comments and remarks in this Word document to the following questions with regards to the period 2019 - 2020. Before you commence, consider doing the following, which is optional:
Go to the investor relations page of both Valero and PBF Energy and listen to fifteen to
thirty minutes of one of the companies latest investor calls.
Locate on their investor relations page any of the presentations recently made by Valero and PBF at investor conferences and and review one recent presentation by each company. Once you have completed the above Solvency Ratios (20%)
1)
Based upon your analysis of the solvency measures, how would compare the ability of Valero and PBF to withstand a significant credit event such as a recession or other event? (50 to 75 words)
2)
Has Valero and PBF improved, declined or remained stable with regards to solvency during the period 2019 through -2020? (50 to 75 words) 3)
Search the internet or financial statements and define the interest rate Valero and PBF pay on their debt. (25 to 50 words)
4)
Based upon your analysis, compare and contrast Valero and PBF’s performance with regard to working capital management (inventory, accounts receivable, accounts payable and cash conversion cycle) (50-75 words)
5)
Provide any other observations you think are meaningful with regards to solvency measures of these two companies. . (25 to 75 words)
Step 2 - Performance Ratios (20%)
1)
Compare and comment upon the relative performance on each of the Performance Ratios for Valero over the period 2019 – 20. Did Valero’s performance improve, decline or remain stable? What support would you offer to support your position? (25 – 75 words)
2)
Compare and comment upon the relative performance on each of the Performance Ratios for PBF over the period 2019-2020. Did PBF performance improve, decline or remain stable? What support would you offer to support your position? (25 – 75 words)
3)
Compare and comment over the relative performance Valero versus PBF for the period 2019-2020. Which company do you think performed better? What support would you offer to support your position? (25 -75 words)
4)
What happened in 2020 that may have resulted in steep performance declines You may want to listen to the transcript of an investor call during these respective periods. Investor call transcripts are available on the website of each respective company on the Investor Relations page. (25-75words)
5)
Provide any other comments or observations that you think are interesting or meaningful with regard the performance ratios of these two companies . (25-75 words)
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
FINAL EXAM Managerial Finance.pdf - Adobe Reader
File Edit View Window Help
Оpen
1
73.8%
Tools
Fill & Sign Comme
Sign I
• Export PDF
• Create PDF
• Edit PDF
1- Evaluate the following projects using the payback method assuming a rule of 3
for payback.
years
• Combine PDF
Project A
-10,000
Project B
-10,000
Year
• Send Files
1
4,000
4,000
Store Files
Full-screen Snip
4,000
3,000
3
4,000
2,000
Acrobat.com
4
1,000,000
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
I just need the answer for #3 Justify/Support your level of planning materiality the measurement base and the percentage
arrow_forward
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:
Sales
Labor and Raw Materials
May, 2020
$75,000
$80,000
June, 2020
$115,000
$75,000
July, 2020
$145,000
$105,000
August, 2020
$125,000
$85,000
September, 2020
$120,000
$65,000
October, 2020
$95,000
$70,000
November, 2020
$75,000
$30,000
December, 2020
$55,000
$35,000
January, 2021
$45,000
N/A
Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
arrow_forward
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:
Sales
Labor and Raw Materials
May, 2020
$75,000
$80,000
June, 2020
$115,000
$75,000
July, 2020
$145,000
$105,000
August, 2020
$125,000
$85,000
September, 2020
$120,000
$65,000
October, 2020
$95,000
$70,000
November, 2020
$75,000
$30,000
December, 2020
$55,000
$35,000
January, 2021
$45,000
N/A
Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
arrow_forward
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:
Sales
Labor and Raw Materials
May, 2020
$75,000
$80,000
June, 2020
$115,000
$75,000
July, 2020
$145,000
$105,000
August, 2020
$125,000
$85,000
September, 2020
$120,000
$65,000
October, 2020
$95,000
$70,000
November, 2020
$75,000
$30,000
December, 2020
$55,000
$35,000
January, 2021
$45,000
N/A
Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…
arrow_forward
The City of Minden entered into the following transactions during the year 2026.
1.
2.
3.
4.
A bond issue was authorized by vote to provide funds for the construction of a new municipal building, which it was estimated
would cost $1,080,000. The bonds are to be paid in 10 equal installments from a Debt Service Fund, and payments are due
March 1 of each year. Any premium on the bond issue, as well as any balance of the Capital Projects Fund, is to be transferred
directly to the Debt Service Fund.
An advance of $74,000 was received from the General Fund to underwrite a deposit on the land contract of $111,000. The
deposit was made.
Bonds of $992,000 were sold for cash at 102. It was decided not to sell all the bonds because the cost of the land was less
than expected.
Contracts amounting to $884,000 were let to Sunny and Company, the low bidder, for construction of the municipal building.
5.
The temporary advance from the General Fund was repaid and the balance on the land contract was…
arrow_forward
SUMMATIVE ASSESSMENT ACTIVITIES
60% pass mark
Instructions: The following assignments must be completed by you in full. Read the instructions carefully
and ensure that you cover all the requirements of the assignments thoroughly. Check to ensure that you
have referenced each Assignment correctly and included all the required attachments
Important note: Should any additional information / documents be required or attached, kindly ensure
that you have referenced them accurately as identified in each section.
Remember: This is a NOF Level 6 qualification requiring comprehensive, in depth evidence that clearly
shows your ability to analyse and evaluate, if there are any sections where you do not have workplace
evidence, simulate the activities through role play
Case Study
Hash-Singh CC trading under Kop lee Foods is a food manufacturing company based in Julius industrial
Park situated in Rustenbure. The company was founded in 1942 by the offspring of the Gani family
who was sent as…
arrow_forward
A. Post the journal entries to their ledger using T-Account Format. Use Additional information on Enrichment Activity 2-1 and use the trial balance for the beginning balances.
B. Prepare Trial balance, as of April 30, 2021.
arrow_forward
E-17 Computing working capital changes
arrow_forward
. The following seven activities constitute an overall bar chart portrayal of a six-month project.
Month 1
0.5
Month 2
Month 3
Activity
Develop Project
Charter
Cost
Month 4
Month 5
Month 6
$1,500
Develop Work
Plan
$8,000
0.5
0.5
Develop
Specifications
Design
Framework
$5,000
0.5
$15,000
Build the
$11,500
0.5
Framework
Test the
Framework
$2,000
0.5
Implement
Framework
$20,000
Note: 0.5 means half month
Three months after the start of the project, activities develop project charter, develop work
plan, develop specifications, 70% of design and 20% of building were completed for a cost
of $28,500. Evaluate the status of the project. For this project, using earned value concepts
determine the percent schedule variance, the percent cost varjance, cost performance index,
schedule performance index, the percentage completion, and estimate at completion. State if
the project is over or under budget and if it is ahead or behind schedule. (show detail
calculation)
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Determine the amount of revenue to be recorded
Looking for answers. please include all the calculation for my reference. Thanks!
arrow_forward
Please answer parts 7, 8, and 9.
arrow_forward
Every entry should have narration please
Problem 1
November 19, 2020, BG Ltd purchased a mini excavator from an equipment supplier. The cost of the excavator was 560,000, with $6,000 paid in cash, and a note for $54.000 with interest on the note at 4% all due on November 18, 2021. BG Ltd. has a year end of December 31.
Prepare all of the entries required for the note in 2020 and 2021.
arrow_forward
AIF Inc. has been monitoring several activity costs for the prior three years to track the
trending of costs from 2021 through 2022, and 2023. The table provides insight:
ACTIVITY
Instructing
Mentoring
Consulting
YE 2021
YE 2022
YE 2023
$487,000
$530,200
$460,000
$653,000
$659,200
$672,000
$1,345,200
$1,290,000
$1,200,000
In analyzing the costs based on trend analysis, AIF Inc would conclude which of the
following correctly? Check all that apply.
Instructing in 2023 had a 5.54% decrease.
Mentoring in 2023 had a 13.24% decrease.
Consulting in 2022 decreased by $90,000
Mentoring costs in 2023 increased by 2.91%
Check here if none of the items are correct.
arrow_forward
Question 1
You are a newly employed finance manager for Finance Adventure Ltd. The following data is available for the company as of 31 June 2020:
Current assets of $293,950
Current liabilities $68,700
Total assets $765,600
Equity $305,890
Required:
a) The company’s Management Board required you to evaluate two alternative options of debt funding and equity funding for a new project. What is the job are you doing to complete the task? (referring to one out of 3 important questions of corporate finance for your answer)
b) Calculate non-current assets, non-current liabilities and build a balance sheet for the company?
c) Calculate the return on assets (ROA) of the company given that return on equity (ROE) is 35%?
d) What is the price earnings ratio (PE) of the company, given total number of outstanding ordinary shares is 57,000 and market price of each share is $22?
arrow_forward
Design a salary slip for the month of December 2021 with information given below.
Fixed vs variable ratio- 70:30Ctc - 18LBasic- 50%Hra- 20%Da - 12%Travel allowance- 2000Insurance - 2500Incentive- 75% target completionPf 12%Earned leaves - 2LOP - 4 Prepare the assignment in Ms excel
arrow_forward
On January 1, 2023, Falcon Construction Ltd. starts a construction project for $4,500,000. Relevant data for 2023 and 2024 are as follows:
2023 2024
Current year construction costs $3,300,000 $ 620,000
Estimated remaining costs to complete 600,000 -0-
Current year billings 3,100,000 1,400,000
Current year collections 3,000,000 1,500,000
Instructions
Prepare the appropriate journal entries for both years using (a) the percentage-of-completion method, (b) the completed-contract method, and (c) the zero-profit method.
arrow_forward
Bare Associates International
9990 Fairfax Blvd, Suite 100 Fairfax VA 22030
www.bareinternational.com
Ms. Nicole Hartford BARE Invoice No.: 3073773
PSB Academy Pte Ltd Client Invoice No.:
15 Sioux Ln Suite 114 Gaithersburg MD, 20878 Purchase Order No.:
Invoice Date: Oct 18, 2024
Payment Due: Oct 21, 2024
Please pay from this invoice and mention the BARE Invoice Number on your remittance.
Date Completed Assignment ID Unit Fees Expenses *Credits Total Due
Count: 0 Sub Total:
Type Project/Description Fees *Credits Total Due
Prepay Project cost - Initial (10%) + Project cost-fieldwork start (40%) of Mystery Shopping Services 2024 $ 6,477.75 $1,000.00 $ 6,477.75
Count: $ 1.00 Sub Total: $6,477.75
Invoice Sub Total: $ 6,477.75
Late Fees: $ -
*Sum of Credits: $ -
Total: $ 6,477.75
Payments $ -
Total Due: $ 7,000.00
arrow_forward
Please do not give image format
arrow_forward
ezto.mheducation.com
Homework: Cost Management and Allocation Assignment
Question 7- Homework: Cost Management and Allocation Assignment- Connect
Homework: Cost Management and Allocation Assignm... i
Saved
Help
Save & Exit
Submit
Check my work
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments
(Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the
year ended December 31 follows.
4.
points
Administration Communications
Facilities
Deposits
$8,320,000 $4,600,000
447, 000
Loans
Direct costs
$200,000
24,000
$290,000
31,000
$253,000
20,500
Employee hours
Number of employees
Square footage occupied
Skipped
360,000
8.
14
6.
230
130
4,600
13,800
5,100
244, 100
203,300
The costs of the service departments are allocated on the following bases: Administration, employee-hours; Communications, number
of employees; and Facilities, square…
arrow_forward
Need help please show work
Flappy Software began a new development
project in 2019. The project reached
technological feasibility on Sept 30, 2020 and
was available for release to customers at the
beginning of 2021. Development costs
incurred prior to Sept 30, 2020 were
$3,000,000 and costs incurred from Sept 30
to the product release date were $700,000.
2021 revenues from the sale of the new
software were $8,000,000 and the company
anticipates additional revenues of
$16,000,000. How much will be capitalized as
software development costs?
arrow_forward
How much is the gross profit realized in 2019?
A. P1,600,000
B. P1,350,000
C. P500,000
D. P250,000
arrow_forward
Problem 1 – Smith College has a fiscal year end of 6/30/22 and runs summer session classes from 6/1/22
to 8/31/22. The following are selected transactions of Smith College;
6/1/22 Smith College collects $300,000 tuition for the 2022 summer session
6/1/22 Smith College collects $1,000,000 tuition for the Fall 2022 semester
6/1/22 to 6/30/22 Smith College pays $2,000 to faculty teaching in the summer session
7/1/22 to 8/31/21 Smith College pays $4,000 to faculty teaching in the summer session
Required:
Prepare the journal entries for the above transactions assuming Smith College is a private sector
not for profit college
Prepare the journal entries for the above transactions assuming Smith College is a State college
arrow_forward
Please help with correct answers asap
arrow_forward
please answer all parts with steps plus explanation , computation , formula for better understanding answer in text thanks
arrow_forward
CE( ED) CV ( CVY)
2008 -15.70%|
Year
-43.40%
2009
23.80%
-9.90%
2010
14.90%
1.40%
2011
30.80%
-3.60%
2012
-6.70%
43.70%
2013
3.80%
47.40%
2014
24.80%
0.30%
2015
1.40%
10.80%
2016
18.90%
69.00%
2017
19.30%
2.20%
arrow_forward
Please with answering the required questions 1,2,3, and 4. Thanks!
arrow_forward
The following diagrams represent one type of project status report. Explain the meaning of each diagram and tell me which diagram is
preferable.
Progress
no learning time
Time
Progress
About 30% of the work done
70% to 80% of the time gone by
Time
arrow_forward
Please help and can show correct answer
arrow_forward
The City of Minden entered into the following transactions during the year 2026.
1.
2.
3.
4.
5.
6.
7.
8.
9.
A bond issue was authorized by vote to provide funds for the construction of a new municipal building, which it was estimated
would cost $1,080,000. The bonds are to be paid in 10 equal installments from a Debt Service Fund, and payments are due
March 1 of each year. Any premium on the bond issue, as well as any balance of the Capital Projects Fund, is to be transferred
directly to the Debt Service Fund.
An advance of $74,000 was received from the General Fund to underwrite a deposit on the land contract of $111,000. The
deposit was made.
Bonds of $992,000 were sold for cash at 102. It was decided not to sell all the bonds because the cost of the land was less
than expected.
Contracts amounting to $884,000 were let to Sunny and Company, the low bidder, for construction of the municipal building.
The temporary advance from the General Fund was repaid and the balance on the land…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- FINAL EXAM Managerial Finance.pdf - Adobe Reader File Edit View Window Help Оpen 1 73.8% Tools Fill & Sign Comme Sign I • Export PDF • Create PDF • Edit PDF 1- Evaluate the following projects using the payback method assuming a rule of 3 for payback. years • Combine PDF Project A -10,000 Project B -10,000 Year • Send Files 1 4,000 4,000 Store Files Full-screen Snip 4,000 3,000 3 4,000 2,000 Acrobat.com 4 1,000,000arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardI just need the answer for #3 Justify/Support your level of planning materiality the measurement base and the percentagearrow_forward
- Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…arrow_forwardStart with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…arrow_forwardStart with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…arrow_forward
- The City of Minden entered into the following transactions during the year 2026. 1. 2. 3. 4. A bond issue was authorized by vote to provide funds for the construction of a new municipal building, which it was estimated would cost $1,080,000. The bonds are to be paid in 10 equal installments from a Debt Service Fund, and payments are due March 1 of each year. Any premium on the bond issue, as well as any balance of the Capital Projects Fund, is to be transferred directly to the Debt Service Fund. An advance of $74,000 was received from the General Fund to underwrite a deposit on the land contract of $111,000. The deposit was made. Bonds of $992,000 were sold for cash at 102. It was decided not to sell all the bonds because the cost of the land was less than expected. Contracts amounting to $884,000 were let to Sunny and Company, the low bidder, for construction of the municipal building. 5. The temporary advance from the General Fund was repaid and the balance on the land contract was…arrow_forwardSUMMATIVE ASSESSMENT ACTIVITIES 60% pass mark Instructions: The following assignments must be completed by you in full. Read the instructions carefully and ensure that you cover all the requirements of the assignments thoroughly. Check to ensure that you have referenced each Assignment correctly and included all the required attachments Important note: Should any additional information / documents be required or attached, kindly ensure that you have referenced them accurately as identified in each section. Remember: This is a NOF Level 6 qualification requiring comprehensive, in depth evidence that clearly shows your ability to analyse and evaluate, if there are any sections where you do not have workplace evidence, simulate the activities through role play Case Study Hash-Singh CC trading under Kop lee Foods is a food manufacturing company based in Julius industrial Park situated in Rustenbure. The company was founded in 1942 by the offspring of the Gani family who was sent as…arrow_forwardA. Post the journal entries to their ledger using T-Account Format. Use Additional information on Enrichment Activity 2-1 and use the trial balance for the beginning balances. B. Prepare Trial balance, as of April 30, 2021.arrow_forward
- E-17 Computing working capital changesarrow_forward. The following seven activities constitute an overall bar chart portrayal of a six-month project. Month 1 0.5 Month 2 Month 3 Activity Develop Project Charter Cost Month 4 Month 5 Month 6 $1,500 Develop Work Plan $8,000 0.5 0.5 Develop Specifications Design Framework $5,000 0.5 $15,000 Build the $11,500 0.5 Framework Test the Framework $2,000 0.5 Implement Framework $20,000 Note: 0.5 means half month Three months after the start of the project, activities develop project charter, develop work plan, develop specifications, 70% of design and 20% of building were completed for a cost of $28,500. Evaluate the status of the project. For this project, using earned value concepts determine the percent schedule variance, the percent cost varjance, cost performance index, schedule performance index, the percentage completion, and estimate at completion. State if the project is over or under budget and if it is ahead or behind schedule. (show detail calculation)arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you